Running reports at set times

G

Gingerbread

I want to run a report at set times, ususally at month end after hours. is
there a way of setting this up in Access.
 
J

John W. Vinson

I want to run a report at set times, ususally at month end after hours. is
there a way of setting this up in Access.

Yes. You can launch Access from the Windows Scheduler, using a command line
such as

"C:\Program Files\yadda\msaccess.exe" "E:\path\yourdata.mdb" /x "runreport"

You would have a macro named runreport; the /x switch will execute that macro.
Be sure to have a Quit line at the end of the macro. Adjust the file and path
names of course.
 
A

aaron.kempf

SQL Server Reporting Services has this functionality built in.. how
much is your time worth?

It's called 'subscriptions' to a report- look into it!

-Aaron
 
Top