Scheduling an ms Access report to run on a specific day

[Jasmine]

I want to schedule an access report to run on Mondays.

Is there a way to perform this within MS Access or do I have to buy a 3rd
party tool

 

[Douglas J. Steele]

You can create a macro to print the report, and use Windows Scheduler (built
into Windows) to open the database and run the macro.

 

[Jasmine]

Thanks for your prompt response.

I was thinking of this option, but how do I pass a parameter in the schedule
to
have that specific report run.

 

[Albert D. Kallal]

You can simply write some code, and have the windows scheduler call that
code.


docmd.Openreprots "name of your report"


the above code would print a report.

I explain how to use a widows script here that can be run by the windows
scheduler.


Batch processing in ms-access (how to run ms-access as a batch job).
http://www.members.shaw.ca/AlbertKallal/BatchJobs/Index.html