Autokeys macro alternative?

[Rhonda]

What could cause an Autokeys macro to suddenly be unable to find a function?
I'm getting an error dialog that states: "The expression you entered has a
function name that MyApp can't find." The Action Failed box then opens to
indicate all correct Macro settings. I tried making the function a Public
Function, but it didn't help.

This has been working for years. Is there a better way of doing this with
code rather than a macro?
Thank you for any suggestions.

 

[Rhonda]

Resolved.
This was caused by Msaccess.exe being renamed to Msaccess97.exe.
I'm fighting other issues using Access 97 & Access 2003 on the same PC.

 

[John Vinson]

Resolved.
This was caused by Msaccess.exe being renamed to Msaccess97.exe.
I'm fighting other issues using Access 97 & Access 2003 on the same PC.

I've got Access 2.0, 97, 2000, 2002 and 2003 all installed on the same
PC, all named msaccess.exe (and I'd be VERY leery of changing the
name). The trick is to install them in chronological order and in
separate folders on the disk.

John W. Vinson[MVP]