Create a Status Bar

  • Thread starter Thread starter TERRY
  • Start date Start date
T

TERRY

I have a macro which runs 20 queries within my database.
The macro is run from a button on my switchboard. I would
like to include a status bar (within a form) that pops up
so that users can see how long there is left before the
macro is complete.Can anyone help?
 
Take a look at my ProgressMeter sample database on
www.daiglenet.com/msaccess.htm which demonstrates several different ways of
doing progress meters. In my examples, I use an iterative procedure and
increment the progress bar with each iteration. You will probably need to
revise this approach to instead, increment the meter after each query
completes.

Using this approach however is a little skewed since it assumes that each
query takes the same length of time. If this is not satisfactory, you may
want to look into using a timer for incrementing the meter instead.
 
Back
Top