Reports to run automatically in Access?

R

Rick B

Not using any built in functionality. If the database is open, yo ucan have
code that runs and checks the system date and time to perform functions.
 
D

Dodo

Can you schedule monthly reports to run automatically in Access?

There are some command line options available for Access. See:

http://www.vb123.com/workbench/help/commandline.htm

Using the switch "/x macro_name" will execute that macro, so if you create
a shortcut like

c:\office\msaccess.exe "C:\path_to_your_database
\name_of_your_database.mdb" /x macro

and have it executed in (task) scheduler it will at the date/time open that
database in Access and run the macro.
If you include action to open and print the report you probably get more or
less what you are looking for.
 

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

Top