Is there a way to schedule Access to run queries or reports at specific 

times? Can you have it automatically run a report on a repeated schedule 

each week? If there is not a way in Access is there some outside plugin or 

tool that can do this functionality within Access? Thanks for the help.

Import the database into a separate database with the queries in a macro

name autoexec and use the Task Scheduler to execute the database week, daily

or whenever.



-----Original Message-----

From: brose@u... [mailto:brose@u...]

Sent: Wednesday, August 15, 2001 2:42 PM

To: Access

Subject: [access] Scheduled Runtimes in Access





Is there a way to schedule Access to run queries or reports at specific 

times? Can you have it automatically run a report on a repeated schedule 

each week? If there is not a way in Access is there some outside plugin or 

tool that can do this functionality within Access? Thanks for the help.

There is a command line parameter for MSAccess.exe that you can use to have

Access execute a named macro (from which you can call VBA code if need be).

You can schedule the command line to run using the Scheduled Tasks in

control panel (if you're running Win2k) or in whatever other job scheduler

comes with your OS.



HTH,



-Roy



-----Original Message-----

From: brose@u... [mailto:brose@u...]

Sent: Wednesday, August 15, 2001 11:42 AM

To: Access

Subject: [access] Scheduled Runtimes in Access





Is there a way to schedule Access to run queries or reports at specific 

times? Can you have it automatically run a report on a repeated schedule 

each week? If there is not a way in Access is there some outside plugin or 

tool that can do this functionality within Access? Thanks for the help.

You can use the Scheduled Tasks program in Control Panel to run the

program automatically.  You then pass a command line argument to your

program to have it perform the tasks you want it to.



1. Just run the Scheduled Tasks Wizard and follow the prompts. 2. After

you have run the wizard, open the task you just created and add a

command line argument at the end of the "Run:" field.  For example: If I

want to automatically run an Access db called MyDB, the "Run:" field

would have the following in it: "C:\Program Files\Microsoft

Office\Office\msaccess.exe" "U:\Work\MyDB" /cmd Autorun a. The

"C:\Program Files\Microsoft Office\Office\msaccess.exe" tells the

program which Access program to use (I have Access 97 and Access 2000 my

computer. b. The "U:\Work\MyDB" is the name of the database and it's

directory c. /cmd Autorun is the command line argument the database will

use. 3. Add code to your program to recognize the command line argument

"Autorun".  I always have a form open automatically in my programs, so

in the Form_Open event, I add code for the program to process data when

the command line has "Autorun".  For example:



Private Sub Form_Open(Cancel As Integer)



    ' If the program is opened through the Windows Task Scheduler then _

	automatically run the program.

    If Command$ = "AutoRun" Then



	' cmdRunApp is a button that, when pressed processes data

        	cmdRunApp_Click



	' Quit the program after processing is complete

DoCmd.Quit

    End If



End Sub



I hope this helps



John Ruff - The Eternal Optimist :-)



-----Original Message-----

From: brose@u... [mailto:brose@u...] 

Sent: Wednesday, August 15, 2001 6:42 PM

To: Access

Subject: [access] Scheduled Runtimes in Access



Is there a way to schedule Access to run queries or reports at specific 

times? Can you have it automatically run a report on a repeated schedule



each week? If there is not a way in Access is there some outside plugin

or 

tool that can do this functionality within Access? Thanks for the help.

There is a 3rd party software that manages multiple database on a 

predefine schedule.  www.fmsinc.com  Total Visual Agent 2000 will not 

only

compact and archive your database at a given time (ex. Midnight @ 

everyday), it can run a macro or command (You can set a macro that will 

generate a report and email, or print the report automatically at a given 

time or day).  You can download a demo from the website metion.

But, if you want to do this in access you would have to have the database 

open at the time of extraction and on a form or module (Autoexec) you 

would have predefine

variables (reportname to print a report or To, CC, Subject, Message, 

reportname to send through email with the report as an attachment).



Good luck,



>>> <brose@u...> 08/15 6:42 PM >>>

Is there a way to schedule Access to run queries or reports at specific

times? Can you have it automatically run a report on a repeated schedule=20



each week? If there is not a way in Access is there some outside plugin 

or

tool that can do this functionality within Access? Thanks for the help.