how do I scheduling reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone tell me how to schedule reports to run automatically in Access or
Visual Basic?
 
Can anyone tell me how to schedule reports to run automatically in Access or
Visual Basic?
Click to expand...

The Windows Scheduler accessory can open an Access database or execute
a VB program on a schedule. If the report is in Access, you can have a
macro (named RunReport let's say) which opens the report; in the
command line in the scheduler you can execute the macro:

msaccess.exe "X:\SomePath\yourdata.mdb" /x RunReport

John W. Vinson[MVP]
 
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

Conditional Expression on automatically populated field 1
VBA in Access 2007 1
Access 2007-Table not displaying the values from a combo box 2
how do i automate Sharpoint list updates 2
Access won't open from batch file when scheduled 3
Schedule 1
Scheduling by using dates 2
Volunteer Scheduling 2

Back
Top