Running reports at set times

  • Thread starter Thread starter Gingerbread
  • Start date Start date
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.
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Hours over 24 hours in Access Report 0
Report Query Works 2nd Time, But Not 1st 14
General MS SQL Question - Sorry if wrong forum 2
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Reporting Groups 3
reports slow after converting to Access 2007 6
New Dell PC 6
Running reports in a multiuser VB/Access environment 0

Back
Top