Msgbox & Timing?

  • Thread starter Thread starter Turner
  • Start date Start date
T

Turner

I have a program that executes Five seperate functions
when the users clicks the "Run" button.

The program reports the completion of each function by
updating the applicatin form with a "Completed"
or "Failed" status along with the time taken to execute
the function. When all is well it works perfectly.

The application even automatically recovers its primary
data Db from a backup if it were missing. And there lies
the problem.

I have a Msgbox informing the user the Db is missing and
will be recovered. So far so good.

However, when a second MSGBOX is displayed informing the
user the recovery is complete the problem begins.
When the user clicks the "Ok" button the MSGBOX form does
not close nor does the application form get updated with
the applications progress until the program finishes.

There is a "Me.repaint" instruction at the end of each of
the five functions so the form should update, but it's
not.

The application completes all functions correctly. This
is strickly an issue with the Msgbox not closing and the
form not being updated in a timely manner.

Thaks;

Dean
 
Sometimes, Access needs to be forced to take a breather and
let the OS catch up. Try putting a call to DoEvents after
the Me.Repaint e.g.
Me.Repaint
DoEvents

Hope This Helps
Gerald Stanley MCSD
 
Back
Top