How to write module to set time schdule to run automatically?

[acin0026]

I had a macro to run my work. However, I would like to have this macro to run task automatically at 6:00 AM. I think I need to write the module. What is the code to do this?

thank for your help.

 

[Aivars]

Hi!

You can try it:

Private Sub Form_Timer()
'You need to place interval (milisecondes: 30000 = 30 seconds) on forms timer interval
If Time >= #6:00:00 AM# Then 'Compare time
DoCmd.RunMacro "MacroName"
Me.TimerInterval = 0 'Stop On Time event further
End If
End Sub

Aivars