Form Refresh Delayed -- Workaround?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a long process that runs numerous queries and procedures. To give the
user some indication that something is happening, I put a sort of "progress
meter" on the form: as the process runs, at various points a label appears
saying what's being done and showing the time it started.

Problem is that sometimes the form isn't immediately refreshed because (I
presume) something else is tying up the processor. I've thrown in some
"DbEngine.Idle's" at various points, but it didn't do the job. Any
suggestions on nifty ways to pause the process long enough for the form to be
refreshed before things move on to the next query or procedure?
 
LarryP said:
I have a long process that runs numerous queries and procedures. To give the
user some indication that something is happening, I put a sort of "progress
meter" on the form: as the process runs, at various points a label appears
saying what's being done and showing the time it started.

Problem is that sometimes the form isn't immediately refreshed because (I
presume) something else is tying up the processor. I've thrown in some
"DbEngine.Idle's" at various points, but it didn't do the job. Any
suggestions on nifty ways to pause the process long enough for the form to be
refreshed before things move on to the next query or procedure?
Click to expand...


First try using Me.Repaint
then try DoEvents
then try both
 
Back
Top