run Procedure at a certain time daily, from Access 97

[burgesse]

How can I make a procedure run at a certain time everyday. I was thinking about using the "

If Timevalue= 12:00:00 then
RunMacro "X"
End If


But How would I execute this procedure. Is there a better way todo what I am trying to do?

 

[Paddyo]

Hi

User a timer control on a form. Set the timer interval to be whatever you want.

The form must be open all the time.

IN the timer event you would put somthing similar to your code above. If you start your automated procedure, set the timer interval to 0 and when you are finished set it back to the original setting. This will stop multiple instances of you procedure running.

Hope this helps