Good day,
I found the following code:
I would like this code to run every 1 or 2 hours for as long as the form is open (right now I have to reopen the form if I want to run). Which property event on the form should I place this code into?
Can anyone help me please?
Thank you,
I found the following code:
Code:
Private Sub Form_Timer()
Me.TextTimer.Value = Format(Time, "HH:mm:ss AM/PM")
Static iCount As Integer
iCount = iCount + 1
If iCount = 60 Then
Me.TimerInterval = 0
Call GenerateCertEmail("SELECT * FROM [Qry_EngineerLic-UpCertEmail]")
If Me.TimerInterval = 0 Then
Me.TimerInterval = 125
End If
Exit Sub
End If
End Sub
I would like this code to run every 1 or 2 hours for as long as the form is open (right now I have to reopen the form if I want to run). Which property event on the form should I place this code into?
Can anyone help me please?
Thank you,
Last edited by a moderator: