Macro dilemma

[muscle]

I have the following batch file which executes my one Access macro...

"c:\program files\microsoft office\office\msaccess.exe" d:\Nick\Budget.mdb /X BMS

is it possible to have this execute several macros?? Thanks beforehand.

 

[Pat Hartman]

A macro can run another macro so make one that runs all the other macros.

 

[muscle]

Thanks for the reply. That's exactly what I did, and it worked fine. But, when I tried to execute on the main production server, I get the following error message...

Run-time error '2202'
you must install a printer before you design, print, or preview.

Any ideas?

 

[David R]

Well, if you don't have a printer installed, but need to Print Preview a report without outputting it anywhere, try this ingenious idea: http://www.access-programmers.co.uk/ubb/Forum1/HTML/006273.html

HTH,
David R