temporarily stop code

J

JT

When I run a macro, there are several places where I would like to put a
short "wait" or "pause" in the code. I can do it in Excel but how do I pause
the code in Access. Thanks for the help.
 
O

Ofer

Found in prev post given by Graham R Seach

Put this declaration in a standard module:
Public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal
dwMilliseconds As Long)

Then call it like so:
Sleep 2000

' enter the time you want the computer to sleep for
 
Top