timer , delay in VBA

[questionit]

How to set a delay between 2 statements.

If i want to put a delay b/w 2 commands, e.g

Open Form

Wait 1 min

Close form


Help please?

Thanks

[JKing]

All forms have an On_Timer event and a property called TimerInterval that you can set to accomplish this.

TimerInterval specifies the time in miliseconds that the form should wait before executing the On_Timer event code. Setting the TimerInterval programmatically or through the properties window to 60000 would cause the form to wait 1 minute before firing off the event. If you just want to close the form in the event it would simply be.

Private Sub Form_Timer()
    DoCmd.Close
End Sub
 

[questionit]

JKing
and how would i set timer between 2 statements
e,.g

statement 1 - does something

delay

statemen 2 - does something

All forms have an On_Timer event and a property called TimerInterval that you can set to accomplish this.

TimerInterval specifies the time in miliseconds that the form should wait before executing the On_Timer event code. Setting the TimerInterval programmatically or through the properties window to 60000 would cause the form to wait 1 minute before firing off the event. If you just want to close the form in the event it would simply be.

Private Sub Form_Timer()
    DoCmd.Close
End Sub
 

[JKing]

It would be something like:

First event
Statement 1 happens
Set TimerInterval = 1000

Timer event
Statement 2 happens
Set TimerInterval = 0