Progress Meter

[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!

 

[James Goodman]

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

 

[Arvin Meyer]

You might try looking at this one:

http://www.datastrat.com/Download/ProgressBar2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access