Automatically Requery

[sc5502]

MS Access 2010/VBA

The users of the attached query want a third button added that when pushed will cause the query to re-query itself automatically every 3 minutes. How can I do this? Thanks in advance.

[jforbes]

Put the requery code into the Form_Timer event. Then in the new Button's click event, set the Forms timer interval to 3000. ...3000 because the Form Timer uses milliseconds.

I use the following for a Checkbox to toggle a timer off and on:

Private Sub chkTimer_AfterUpdate()
    If Me.chkTimer.Value Then
        Me.TimerInterval = nTimerInterval
    Else
        Me.TimerInterval = 0
    End If
End Sub

[twinnyfo]

P.S. For a three minute interval, TimerInterval should be 180000 (3 minutes, x 60 seconds x 1000 milliseconds).

[jforbes]

Haha, nice catch Twinnyfo!