Run query automatically

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

Guest

I created a make-up table query, and want to have it run everyday at 6:00 am.
Can someone tell me how to make it Run automatically?
 
One way to do it is to create a form that is hidden that
has the timer initiated on it. Set the timer interval to
1000 and in the OnTimer Event, paste the following:

If Format(Time, "h:nn:ss am/pm") = "6:00:00 am" Then
DoCmd.OpenQuery "yourQuery"
End If

try that
 
Back
Top