Is there a autoaction based on time

Topic

New Reply

Need to know if it is possable to have a series of reports to run automaticly in access2000 with out promting the user to do it and have it based on a time of say as in

If it is 6 am in the morning automaticly run such and such reports.

Dom

Reply | Quote

Replies

Hi Dom,

There have been several threads discussing automating things in Access to happen at a certain time. The best way I would recommend is to create a macro for the desired process, then use the Windows Task Scheduler and an Access Command-Line switch to have the process run at a desired time. For example, if your macro is named “mcrPrintMorningReports” you could put the following command line in the Windows Task Scheduler (for 6AM every weekday):

"C:Program FilesMicrosoft OfficeOfficeMSAccess.exe /x mcrPrintMorningReports"

Post back if you need more info…HTH

Reply | Quote

MarkJ

THANK YOU VERY MUCH

That saves me alot work soon as I try it. Now I just need to get them to get the actions they want me to do for it.

Dom

Reply | Quote

Good Morning,

I am currently running reports and other tasks by using the Scheduler program which you can download for free from ..http://www.mvps.org/access/.

What I did was write a public function to determine what day it was and in the OnOpen event of a hidden form, which is loaded OnOpen of the db, is call the public function. After the reports print, a PrintLog is updated with what reports were printed and when. A dialog also informs of the reports that printed, I click OK…the db closes…until the next day. This way the REPORTS db could house ALL reports that are printed progmatically.

The scheduler program knows what day, time and database to open…then Access does the rest…

Hope this helps and good luck.

Reply | Quote