Macro calls another macro in another database

[CQ]

Ok, I thought this would be sooooo easy, maybe I just
don't understand. I want to set up an "autoexec" macro
in an otherwise empty database. I want that macro to go
out and run a macro in another database. I need to
understand the command in the macro in the first database
and the "code" to actually point it to the second
database.

 

[Steve Schapel]

CQ,

I think you could use the RunApp action in the macro in the first
database. The command line argument needs to be something like this...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\2ndDB.mdb" /x NameOfMacro

 

[Guest]

Thank you Steve, I will try it on Monday!

-----Original Message-----
CQ,

I think you could use the RunApp action in the macro in the first
database. The command line argument needs to be something like this...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\2ndDB.mdb" /x NameOfMacro

--
Steve Schapel, Microsoft Access MVP


.