Access 2002 macros can't find user funtions

  • Thread starter Thread starter Birk Binnard
  • Start date Start date
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?
 
Never mind...I found another message with the same problem and solution:

Installing Jet 4.0 SP8 and MDAC 2.8 resolved the problem.
 
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
 
Back
Top