由神秘对象调用的宏。 [英] Macro invoked by mystery object.

问题描述

我有一个表单（单表单视图 - 绑定到tblVisit），打开时，给我错误消息Microsoft Access无法找到宏'providerMenu''。


问题是，表单上没有设置事件处理程序（根据属性对话框），尽管可能曾经一度被删除过。我还查看了表单上的每个控件，并且没有任何事件处理程序设置。有什么方法可以找出调用这个宏的内容，还是Rod Serling的工作？对于那些太年轻（哎哟）的人来说，这是一个暮光之城的笑话。


我正在使用Access 2003.

I have a form (Single Form view - bound to tblVisit) that when opened, give me the error message "Microsoft Access can''t find macro ''providerMenu''."

Problem is, there are no Event handlers set on the form (according to the Properties dialog box), although there may have been at one time that have since been deleted. I''ve also looked at every control on the form and there are no Event handlers set anywhere. Is there any way to find out what is invoking this macro or is this a job for Rod Serling? It''s a Twilight Zone joke for those of you who are too young (ouch) to remember.

I''m using Access 2003.

推荐答案

可以是腐败的迹象，创建一个新的空数据库并使用文件/获取外部数据/导入。得到一个新鲜的所有物品的副本。


Nic; o）

Can be a sign of corruption, create a new empty database and use "File/Get external data/Import" to get a "fresh" copy of all your objects.

Nic;o)

我对你答案的第一反应是哦，好的。扔了相当多的讽刺，但如果它能解决这个问题，我会试一试。这是一个相当大的数据库，所以我想我知道这个周末我会做什么。


感谢nico5038，非常感谢你的帮助。

今天的口头禅：制造备份 - 更多 - 经常制作 - 备份 - 更经常地制作备份 - 更经常......

My first reaction to your answer was "Oh, goody" with a fair amount of sarcasm thrown in, but if it will fix the problem I''ll give it a shot. This is a fairly large database, so I guess I know what I''ll be doing this weekend.

Thanks nico5038, I really appreciate your help.

Today''s mantra: make-backups-more-often make-backups-more-often make-backups-more-often...

它是并没有太多工作，因为文件/获取外部数据/导入显示一个弹出窗体，允许您选择每种类型的所有对象（表/查询/等）。


一般来说，当数据库行为奇怪时，我的第一个动作。 反编译是指反编译。是更重，但会更加固定。 （ http://www.granite.ab.ca/access/decompile .htm 。


成功！


Nic; o）

It''s not really much work, as the "File/Get external data/Import" shows a pop-up form allowing you to select all objects per type (Table/Query/etc.).

It''s in general my first action when a database acts strange. A "decompile" is "heavier", but will fix even more. (http://www.granite.ab.ca/access/decompile.htm.

Success !

Nic;o)

这篇关于由神秘对象调用的宏。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！