Scheduling an ms Access report to run on a specific day

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jasmine - 19 Jul 2007 20:05 GMT

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

Reply to this Message

Douglas J. Steele - 19 Jul 2007 20:16 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>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

Reply to this Message

Jasmine - 19 Jul 2007 20:26 GMT

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.

> You can create a macro to print the report, and use Windows Scheduler
> (built into Windows) to open the database and run the macro.
[quoted text clipped - 3 lines]
>> Is there a way to perform this within MS Access or do I have to buy a 3rd
>> party tool

Reply to this Message

Albert D. Kallal - 19 Jul 2007 20:33 GMT

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

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message