Custom Status Bar

  • Thread starter Thread starter Dom
  • Start date Start date
D

Dom

Hello Everyone,

I have a form (frmQtrlyRpt) which performs lots of
calculations from 4 different queries. When you open the
form, the form is blank because it's calculating but the
user does not really know that. My question goes as
follow: Is there a way to create a custom status bar which
displays the calculation progress and close when it's done
calculating and open the form (frmQtrlyRpt) with all the
information displayed ?

Thanks in advance.
 
The reason your form is blank is because all the CPU is going to the
calculations - if you use the DoEvents statement before and between the
queries, Access will yield CPU long enough to allow the lower priority tasks
to complete - ie repainting the form.

You can also implement a progress meter - to see some examples of this check
out the Progress Meter example at http://www.daiglenet.com/MSAccess.htm
 
Back
Top