Command Buttons and Macros Gone Awry

[Guest]

I have a 3-4 year old db in Access 2000 and without doing anything to it, I
receive the following message when clicking on a command button or macro:

The expression On Click you entered as the event property setting produced
the following error: The expression you entered has a function name that
"DATABASE NAME" can't find.

*The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

Please tell me there is a fix for this. As far as I know, no one did any
mods to the db to make this happen. It is occuring on the switchboard as
well as all of the forms. Please help. Thanks.

 

[Pieter Wijnen]

Probably related to dll version problems (service packs o.a)
try opening the database with the /decompile switch (holding down SHIFT till
you get a message saying "ms access have converted your code to the current
version of VBA")
ie make a shortcut as follows:

<path to access>\msaccess.exe <path to database>\db1.mdb /Decompile [<other
required switches>]

HTH

Pieter

 

[Guest]

Thanks for your help Pieter. It wouldn't work for me, but I finally got it
fixed. Don't really know how, though. Someone else opened the file
(possibly they had the updated service pack/dll) and it fixed. Thanks again.
--
Cindy

Probably related to dll version problems (service packs o.a)
try opening the database with the /decompile switch (holding down SHIFT till
you get a message saying "ms access have converted your code to the current
version of VBA")
ie make a shortcut as follows:

<path to access>\msaccess.exe <path to database>\db1.mdb /Decompile [<other
required switches>]

HTH

Pieter

I have a 3-4 year old db in Access 2000 and without doing anything to it, I
receive the following message when clicking on a command button or macro:

The expression On Click you entered as the event property setting produced
the following error: The expression you entered has a function name that
"DATABASE NAME" can't find.

*The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

Please tell me there is a fix for this. As far as I know, no one did any
mods to the db to make this happen. It is occuring on the switchboard as
well as all of the forms. Please help. Thanks.