Access report

[Luis]

Hello all, I am not a programmer and I need to print and access 2003 report
actomatically every hour starting at 8:00 AM and finishing at 5:00 PM. Any
macro, routine or query someone can send to me?. Thank you.

 

[Albert D. Kallal]

If your application has no startup forms etc, then in a standard module

(lets call the code module basDailyRun)

You can place the following code that would launch the report


Public sub RunMyDailyReport

docmd.OpenReport "name of your report goes here"

end sub

now, you can build a windows script as outlined here:

http://www.members.shaw.ca/AlbertKallal//BatchJobs/Index.html

the above script outlined in the above can then be placed in the windows
scheduler that can run it once every hour....