数据透视表不允许布局编辑 [英] Pivot Table Form not allowing Layout Edits

问题描述

我正在使用Access 2002（XP），SP3，（10.6771.6817）开发数据库。我创建了一个带有数据透视表的表单，在我的计算机上查看时，一切正常（使用Win XP SP2英文版）。但是当我在西班牙语访问版本（10.4302.6714）中显示该数据库时，他可以打开表单，但他没有启用任何上下文菜单项。 表单'上下文菜单中的所有内容都已停用。他可以从同一个查询创建另一个数据透视表，但同样，他不能移动或编辑字段，也不能显示字段列表。他在2台不同的计算机上尝试了数据库，结果相同。当他选择菜单数据透视表时，仅刷新按钮。已启用，并且在我的计算机中，所有内容都已启用。


数据库不是只读，也不是文件本身。

我已经尝试了谷歌的许多kewords，但没有任何运气。


会发生什么？任何评论都将不胜感激。

I''m developing a database using Access 2002 (XP), SP3, (10.6771.6817). I have created a form with a Pivot Table, and when reviewing it in my computer, everything is working ok (using Win XP SP2 English). But when I show that database in a Spanish Access version (10.4302.6714), he can open the form, but he do not have any context menu item enabled. Everything in the form''s context menu is disabled. He can create another Pivot Table from the same query, but again, he can not move or edit fields, nor showing the field list. He tried the database in 2 different computers with the same result. When he selects the menu "PivotTable", only "Refresh" is enabled, and in my computer, everything is enabled.

The database is not "read only", nor the file itself.

I''ve tried Google with many kewords, but without any luck.

What could be happening? Any comment would be appreciated.

推荐答案

检查错误机器上的引用。


打开一些VBA代码（例如，通过按[CTRL + G]）并选择工具/参考。

每个以MISSING开头的库名。必须取消选中并且（例如微软DAO版本x.xx）必要时更换。


由于访问没有清理添加的库，通常不会有不必要的refenreces。

只需尽可能多地删除而不会出现错误执行调试/编译所有模块


Nic; o）

Check the references on the "error machine".

Open some VBA code (e.g. by pressing [CTRL+G]) and select Tools/References.
Each libraryname starting with "MISSING" must be unchecked and (e.g. microsoft DAO version x.xx) replaced when necessary.

As access doesn''t cleanup added libraries, often unnecessary refenreces are present.
Just delete as many as possible without getting an error executing "Debug/compile all modules"

Nic;o)

谢谢期待你的答复！几分钟前我已经检查过了，没有，没有MISSING组件。


还有其他任何建议吗？ 锁定 form？

Thanks for your reply! I''ve checked it a couple of minutes ago and no, there are no MISSING components.

Any other suggestion? A "locked" form?

有没有办法锁定数据透视表，使其成为只读？我的意思是，如果可能发生这种情况，那么另外就是解决方案......

Is there a way to lock the Pivot Table, make it "read only"? I mean, if that could be happening, making it otherwise would be the solution...

这篇关于数据透视表不允许布局编辑的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！