temporarily stop code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top