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, like this:. DoEvents releases time to other processes on the computer. However, this method consumes almost all the CPU time and slows down the PC considerably because there's no pause in the processing. As soon as the DoEvents command executes, it executes again and repeats as fast as the PC can run.
Effective Resume Writing
Program won't quit
Handling Errors Introduction to Errors A computer application is supposed to run as smooth as possible. Unfortunately, this is not always the case. A form may close unexpectedly. A control on a form may hide itself at the wrong time.
VBScript For Loops
George Hester. Tom Esh. After the End If? Set a breakpoint on the "If Instr
Althought, for additional reason, the late binding is not force any error in my case. It could work for first time, but never more before closing Access and reopen. This is a very informative page. I''ve been struggling with this problem for a while. Also, I now understand late binding, which is a concept I was familiar with, but never had an example to which I could relate.