|
||||
|
Sleep Seconds By Richard Rost ![]() ![]() ![]() This procedure will determine how long Alex naps for.
Usage: Put the above in a global module, then anywhere in your database you can say something like this to sleep for 5 seconds:
The purpose of the loop is to make SleepSec responsive. If you sleep for 10 seconds without any DoEvents, then your code might appear to freeze. If this interferes with performance or function for you, just set it to FALSE. Note: If you are still running machines using 32-bit Office, then use this for your declaration in the global module:
This will compile the database according to the version of Office on your PC. Video: This code is explained in my Sleep TechHelp video.
|
||
| |||