Running a macro automatically

[lblue]

Hello all,

I am trying to make a macro run nightly. I have a task scheduler to open the database, and on the opening form I have put a time interval code set. However, I am unsure what time interval amount I should put. Let's say I put 6000. Upon testing this, it printed the report continuously every 6 seconds.

How can I make it run just once, then stop?

This is the code I used, thanks to a 2007 post on here:

Private Sub Form_Timer()
If intCounter > 1 Then
  Me.TimerInterval = 0
  DoCmd.Quit
Else
  DoCmd.RunMacro "mcrTest"
End If
 
intCounter = intCounter + 1
End Sub

thanks in advance!

[Seth Schrock]

For other's reference, here is the link to the thread referenced.

I have done this a few times, and I do what was described in post #2

I've never actually done this, and I didn't have the time to test it, but you should be able to run Microsoft Access with the /x macroname Command Line Option as a Daily Scheduled Task if you are using Windows XP. Here is the procedure:
Start Menu
Programs
Accessories
System Tools
Scheduled Tasks
Add a Scdeduled Task
Select Program to Run
Add any necessary Parameters
Select Open the Advance Properties Dialog when finished
Specify the /x macroname Command Line Option on the Command Line

Have your macro call a function that runs your report and then closes the database. You don't need any of the timer form or the If-then-else statement.

[NeoPa]

You can find some extra info at Invoking a Database From the Command Line.
If you want to run it once only, every time it's opened then include the following code at the end :

Call Quit(Option:=acQuitSaveNone)