Access 2002 macros can't find user funtions

B

Birk Binnard

After I upgraded my OS from WIN XP Home to XP Pro Access 2002 can no longer
run an Autoexec (or any other) macro that references a user defined
function. The macro quits with "The expression your entered has a function
name that MyApp can't find" and is pointing to the RunCode statement that
has the name of a user defined function.

I know the function is there and OK because I can run it manually and I used
the RunCode expression builder to set the name of the function into the
macro.

Is there some security trick to getting macros to run in XP Pro?
 
B

Birk Binnard

Never mind...I found another message with the same problem and solution:

Installing Jet 4.0 SP8 and MDAC 2.8 resolved the problem.
 
A

Arvin Meyer

Chances are that you have either a references problem, or a naming conflict.
The easiest thing is to rename the function and change the name in the macro
that calls it. If it is a references problem, open a code window (Ctrl+G)
and go to Tools ... References, then fix and marked as missing. More on
references can be found on Doug Steele's site:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top