Auto Weekly and Month Reports

[SharonInGa]

How do I set up a report to automatically run every Monday morning for Monday
through Sunday of each week.

Also, How do I set up a report to automatically run on the last day of each
month?

 

[Klatuu]

There are a couple of ways to accomplish this. How you do it depends on the
nature of your application. One way would be to have a routine in your
startup form that would check the day of the week, have a way to know if the
current week's reports have been run, and run the reports.

If you require unattended production of the reports, you could create a
separate mdb that would launch your reports process and have that application
run from Windows Event Scheduler.

 

[SharonInGa]

Can you explain in more detail how to set up a separate mdb with a schedular?

 

[Klatuu]

Create a new mdb file
Import all the objects required for your reports
establish links to the tables you need
Either create an Autoexec macro that will run the reports or indentify a
startup form that will run the reports

To set up the scheduler:
From your Windows task bar
Start->Control Panel->Scheduled Tasks->Add Scheduled Task
Follow the Wizard