There may be occasions when you want an application to wait for a specified period of time without performing activity or wait loops. The Timer control can help, but only up to 60 seconds.
The Sleep Windows API function lets you put the application to sleep. Enter the following declaration into a standard module.
Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Then, simply call the function from your code, as in:
In this case, the 5000 milliseconds puts the application to bed for 5 seconds. You can specify your own period of time, though.
This tip was contributed by Malcolm Wright, SIM Desktop Technical Services.