Application.Wait

[JON JON]

Hello NG,

Is the Wait Method not supported in Access? Any workaround? Please note
that I can not use the onTimer event since I will be using the method within
a loop code somewhat like:

For i = 1 to 10
'my code here
Application.Wait Now() + Timeserial (0,0,1)
next i

TIA

 

[Graham R Seach]

Jon,

Public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds
As Long)

Then somewhere in your code:
Sleep 1000 ' =1 second (1000 milliseconds)

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia

 

[JON JON]

That's great! Thanks.

Jon,

Public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal
dwMilliseconds As Long)

Then somewhere in your code:
Sleep 1000 ' =1 second (1000 milliseconds)

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia