Timer Event (1 Viewer)

[Jonny45wakey]

Hi I would like the on-timer event of a hidden form to trigger

DoCmd.OpenForm "formnamehere"

every hour using the computer time, essentially if time (minutes) = 00 then run the docmd

How would this be formatted in VBA please?

Thanks

Jonny

 

[Jonny45wakey]

All

I have sorted this through trial and error, on the hidden form is a textbox "txttime" with bounds to =Now()
and timer interval set to 60 seconds.

When the On Timer event fires the following code opens the second form (which is like a popup form)

Private Sub Form_Timer()
Me.Refresh
If Minute(Me.txtTime) = 0 Then
DoCmd.OpenForm "frmReminder"
End If
End Sub


Regards

Jonny