View Single Post
  #5  
Old July 25th, 2007, 11:28 PM posted to microsoft.public.access.reports
Klatuu
external usenet poster
 
Posts: 7,074
Default Automate Reports

The simplest approach would be to put the reports and any objects they use
into an mdb of their own. Establish the table links as necessary to the bank
end. In other words, you will have a subset of your application that contain
only the reports and any object they need. Create a Macro named AutoExec
that runs the reports.
Use the Windows scheduler to kick off Access with the report mdb on whatever
schedule you want.
--
Dave Hargis, Microsoft Access MVP


"richard" wrote:

I am looking to run a report at the same time each day. This report will need
to run automatically say 5pm each weekday, is this possible and if so, some
pointers would be helpful.

Many Thanks

Richard