Avoid Using DoEvents to Wait in Microsoft Access, VBA, and VB6

In our Microsoft Access, VBA, and VB6 programs, we often need to pause processing for a certain period of time, or until a specific time, and then continue processing. One common way to do this is to use the DoEvents function in a loop while waiting, however, this method consumes the CPU time and slows down the PC considerably. This is a significant problem when pausing for more than a couple of seconds, when users will notice the slow down. Use the Sleep command instead.

This is available in our Total Visual SourceBook!

Leave a Reply

Your email address will not be published. Required fields are marked *