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

 

[Guest]

Albert,
read your article.
I did spend the first two years of my career in IT with punch cards.
We had no terminals, we coded on "coding sheets" and either punched our own
cards or if we were lucky, a keypunch operator did it for us. Yes, Keypunch
Operator was once a job title.

As to your perception of the demise of the batch job, if you spend most of
your time with desktop and/or interactive applications, you may have that
perspective. You may be suprised at how many batch jobs still run every
night, particularly at banks, mortgage companies, and other financial
organizations.

They still are pretty much what they have always been. To be printing tens
of thousands of statements, invoices, etc during business hours would either
degrade online performance or require excessive capital resources.
Also, backups, creating history tables, etc. need to be done when
transaction processing is not running to avoid a "fuzzy" image.

Granted, some processes that used to be done overnight have moved to daytime
processing, but batch jobs are not dead yet.