Running a macro to a schedule

[Guest]

I want to run a report on the first day of each month. I've read that it's
possible to do this with windows scheduler, but I don't know how to get
scheduler to run the macro. All I can get scheduler to recognise is the
database and nothing inside it. Hopefully it's possible, can anyone help?

 

[Tom Wickerath]

Hi Bill,

Use an optional command line switch to specify the name of a macro. The macro would then be used
to open your report.

See http://support.microsoft.com/?id=209207 for information on using command line switches.


Tom
_______________________________


I want to run a report on the first day of each month. I've read that it's
possible to do this with windows scheduler, but I don't know how to get
scheduler to run the macro. All I can get scheduler to recognise is the
database and nothing inside it. Hopefully it's possible, can anyone help?

 

[Steve Schapel]

Bill,

The Command Line argument you would use with your scheduler would be
something like this...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\YourDb.mdb" /x NameOfMacro