Progress Meter

  • Thread starter Thread starter tinab
  • Start date Start date
T

tinab

I have a form with 2 cmd buttons that run macros. One macro runs 2
update queries and the other one runs an append query. I have turned
off the warnings and would like to put progress meters on each of
these cmd buttons so the user can see that something has actually
taken place. I have read other postings regarding this and have
looked at the example listed in one of the postings but I don't
understand. Could someone give me the exact steps I need to take to
accomplish this. Much appreciated!
 
For the macro that runs 2 queries, you could put a progress bar which
updates after completion of each query. However, for the first one you will
only be able to display a query progress of 0 & 100%.

Unfortunately, you cannot interogate query progress, so your options are
fairly limited.

Using the progress bar control is nice & simple. Drop one onto your form, &
it will be named something like ProgressBar1.

To adjust its value:
ProgressBar1.Value = SomeVal

To set its maximum value:
ProgressBar1.Max = SomeOtherVal
 
Back
Top