G Gingerbread Mar 2, 2009 #1 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.
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 Mar 2, 2009 #2 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. Click to expand... 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.
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. Click to expand... 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 Mar 3, 2009 #3 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
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
