FMS Home Page FMS, Inc.
Avoid Using DoEvents to Wait in Microsoft Access, VBA, and VB6

FMS Development Team Blog

Exploring the Latest in Application Development

About FMS

FMS, Inc. is software development company in Tyson's Corner, VA.
E-mail usSend mail

Recent comments

© Copyright 2012 FMS, Inc.

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

In our Microsoft Access, VBA, and VB6 programs, we often need to pauseprocessing for a certain period of time, or until a specific time, and thencontinue processing. One common way to do this is to use the DoEvents function in a loop whilewaiting, however, this method consumes the CPU time and slows down the PCconsiderably. This is a significant problem when pausing for more than a coupleof seconds, when users will notice the slowdown. Use the Sleep command instead.

Learn more about our royalty-free MicrosoftAccess/VBA/VB6 module code.

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

Currently rated 5.0 by 3 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by Molly on Tuesday, May 11, 2010 11:09 AM
Permalink | Comments (0) | Post RSSRSS comment feed
Comments are closed