Re: How can I set the interval property to 30 or 60 minutes?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Raj" <Raj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8CC0D628-8CAB-4142-9EAA-EA49E9E2DC2F@xxxxxxxxxxxxxxxx
How can I set the interval property of the timer control to 30 or 60
minutes,
or once day?

Thank you

Regards
Raj

The Interval property is measured in milliseconds and the max value
for Interval is 65535 or a little over a minute.

Set your Timer's interval to 60000, or 1 minute. Then the timer event
will be called each minute. Set up some static or module level vars
in your Timer routine to count minutes, something like;

Private Sub Timer1_Timer()
Static Min As Long
Min = Min + 1
If Min = 60 Then
Min = 0
'do something once an hour
End If
End Sub



.

Relevant Pages

  • Re: Thinking about an unbound data entry form...
    ... This new data entry form has looser restrictions on data ... > in the timer event during testing since I thought it might affect ... > opens. ... Private Sub Form_Open ...
    (microsoft.public.access.forms)
  • Re: access hijacks desktop
    ... Here is the exact code that runs on the timer event. ... Dim InDs As Integer ... Public Function TestTodayRequery() ... Private Sub ScrollButtonEnable() ...
    (microsoft.public.access.forms)
  • Re: Unable to hide form?
    ... >> resizing it in a Timer event, but I really think using an Autoexec ... Dim mlngHeight As Long ... Dim mlngWidth As Long ... Private Sub Form_Open ...
    (microsoft.public.access.modulesdaovba)
  • Re: Timer Count Down
    ... Private Sub Form_Open ... Inside the form's Timer event, ... Doug Steele, Microsoft Access MVP ... and show it on the form so whenever the user opens the form it will show ...
    (microsoft.public.access.formscoding)
  • Re: Problem hiding a control
    ... Timer event when there's something for it to do. ... Dim mHideMyListbox As Boolean ... Private Sub MyListbox_LostFocus ... control and set the TimerInterval back to 0 in the Timer event. ...
    (microsoft.public.access.modulesdaovba)