rorymurray
Programmer
Does anybody have an idea of how to set an access report to run on a nightly basis at a given time?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
access reports - how to run nightly automatically
- Thread starter rorymurray
- Start date
- Status
tomschafer
Technical User
You'd have to use the OnTimer event of a form to run your report.
Hi!
Another thing you can do is to make database has the reports you want to run and which links back to this db. You can make a macro called autoexec and run the reports from that macro and then close the db from the same macro. If your machine has a scheduler on it, you can schedule the db to open any time and then the reports will run and the db will close.
hth
Jeff Bridgham
bridgham@purdue.edu
Another thing you can do is to make database has the reports you want to run and which links back to this db. You can make a macro called autoexec and run the reports from that macro and then close the db from the same macro. If your machine has a scheduler on it, you can schedule the db to open any time and then the reports will run and the db will close.
hth
Jeff Bridgham
bridgham@purdue.edu
- Status
Similar threads
- Locked
- Question
- Locked
- Question
