ACCESS: How To: Install Short Delay in Module Code [RESOLVED]

[Webtest]

Esteemed Forum Participants and Lurkers:
===============================
Access 2000 (XP) & '97

How do I insert a short in-line delay into my Module Code? I need about 250 milliseconds delay ... execute1, delay, execute2, delay, execute3

Thank you for any and all comments, suggestions, and assistance.

[RobDog888]

You can use the Sleep API.

Private Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)

[Webtest]

Many Thanks RobDog ...

For clarification unto future generations ...
Insert this into the declaration area at the very top of your module:

Private Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)

Here is the inline code:

DoCmd.Beep  'or whatever
Sleep(400)
DoCmd.Beep  'or whatever
Sleep(400)
DoCmd.Beep  'or whatever

[RobDog888]

Hmm, lets see. 3 Beeps means no video or memory error?

[Webtest]

No ... it means "If you forgot to wake up on the 1st beep, here are 2 more!"

[RobDog888]

Sounds similar to one of my first programs I wrote. An alarm clock that called me on the phone because my regular alarm clock
wasnt loud enough