Command Buttons and Macros Gone Awry

C

Cindy

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.
 
P

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
 
C

Cindy

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



Pieter Wijnen said:
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

Cindy said:
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.
Click to expand...
Click to expand...
 
Top