Use macro to call macros in other databases

[Lurch]

Hi Folks;

Is there any way I can have one macro call several other macros in
other Databases? I'm using Access 2k in Windows 2k.

It's just pain in the neck to go to all these macros to update my data
one by one. Would it be easier to just use windows task manager?

Thanks everyone!!

Tony

 

[Rob]

hi,
i think what you need to do is have the macro use the
RunApp function to call the other database to open and
then in the 2nd database, i think if u go to tools-
startup you can pick a macro to run at startup. so
basically, when you use the RunApp and call database 2,
it will open it it up and run the macro. no guarantees
if this will work though, but try it!

Rob