Automated Reports

  • Thread starter Thread starter Chuck
  • Start date Start date
C

Chuck

Can Access run automated reports using VBA without any
user interface? I do not believe that this is possible
with access but here's what I am looking for in
functionality. The front-end db would open up at the
begining of the month, run specified reports based on date
range and dept criteria, and print to local printer (all
without user interface).

To take it one step further, with the reports that have
dept criteria, have an email contact for each dept in a
table for the Access db. When the automated reports runs
for each dept in the db, have that report emailed to the
email contact for the dept. Thanks in advance for your
comments / suggestions on this.
 
Just use your favorite scheduler to start the database and
write code to do the rest. If you want to create pdf files and
email them as attachments we have an example that does just that
using our batch reporting module. For example I use it to do weekly
reports and email them out to VIPs in the company.

HTH,
Mark
RPT Software
http://www.rptsoftware.com
 
Back
Top