Hi there,
I'm running a macro in a database from within another database. I create an instance of an Access application and then call the DoCmd.RunMacro action like this:
Set appAccess = CreateObject("Access.Application")
appAccess.OpenCurrentDatabase strDatabase
appAccess.DoCmd.RunMacro myMacro
appAccess.CloseCurrentDatabase
Set appAccess = nothing
This works perfectly but... since 2 days this construction doesn't work anymore. Access says it can't find a specific function name. It gives this error on the DoCmd.RunMacro line so appearantly it can't find the DoCmd function? But when going into debugmode and waiting for, like, 3 seconds before (!) executing DoCmd.RunMacro, things DO work! Does anyone know what's going on and how I can solve this problem?
Thanks,
Jeroen
Bye,
Jeroen
A 3d level editor in Delphi
I'm running a macro in a database from within another database. I create an instance of an Access application and then call the DoCmd.RunMacro action like this:
Set appAccess = CreateObject("Access.Application")
appAccess.OpenCurrentDatabase strDatabase
appAccess.DoCmd.RunMacro myMacro
appAccess.CloseCurrentDatabase
Set appAccess = nothing
This works perfectly but... since 2 days this construction doesn't work anymore. Access says it can't find a specific function name. It gives this error on the DoCmd.RunMacro line so appearantly it can't find the DoCmd function? But when going into debugmode and waiting for, like, 3 seconds before (!) executing DoCmd.RunMacro, things DO work! Does anyone know what's going on and how I can solve this problem?
Thanks,
Jeroen
Bye,
Jeroen
A 3d level editor in Delphi