Run a Macro every 5 minutes automatically

[GonzaloYagueSunol]

Dear all,

I am using access 2013, I have an update query called "CurrentDate" and it is run by a macro called "TimetoTime". I want to run this macro automatically every 5 minutes. After researching different forums and tutorials, I have created a form with the following code:

------------------------------------------------------
Private Sub Form_Open(Cancel As Integer)
Me.TimerInterval = 300000
End Sub


Private Sub Form_Timer()
DoCmd.RunMacro "TimetoTime"
End Sub

------------------------------------------------

Unfortunately it does not work. I would really appreciate if anyone could help me solve this problem.

Thank you very much in advance.

Best regards,

Gonzalo

 

[pbaldy]

Did you give up on me?

http://www.excelguru.ca/node/7