Pause code

[Stephen sjw_ost]

How can I pause code for a specified amount of time without having the user
press any button(s) or click any "OK's"? I want to be able to control how
long the pause lasts. Is this possible?

Thanks for any help
Stephen

 

[Clifford Bass]

Hi Stephen,

You can use Allen's method or you can just use the Sleep function
available in one of the Windows DLLs. At the top of a plain module, before
any subroutines place this code:

Public Declare Sub Sleep Lib "Kernel32.dll" (ByVal lngMilliseconds As Long)

Then anywhere in code in any module, just use:

Sleep 10000

to pause for 10 seconds.

If it does not automatically change the cursor to a wait cursor, you
also may want to do so so as to indicate to the user that he/she should wait:

DoCmd.Hourglass True
Sleep 10000
DoCmd.Hourglass False

Clifford Bass

 

[Stephen sjw_ost]

This is perfect. Thank you!

Hi Stephen,

You can use Allen's method or you can just use the Sleep function
available in one of the Windows DLLs. At the top of a plain module, before
any subroutines place this code:

Public Declare Sub Sleep Lib "Kernel32.dll" (ByVal lngMilliseconds As Long)

Then anywhere in code in any module, just use:

Sleep 10000

to pause for 10 seconds.

If it does not automatically change the cursor to a wait cursor, you
also may want to do so so as to indicate to the user that he/she should wait:

DoCmd.Hourglass True
Sleep 10000
DoCmd.Hourglass False

Clifford Bass

 

[Clifford Bass]

Hi Stephen,

Great! You are welcome.

Clifford Bass