I have a query that runs for about 10 minutes. Can someone tell me how I can tie a progress bar to the query to indicate the status of execution? Thanks.
If it is a single query then you canot use a progress bar.
If you are looping through a recordset (or some other counter) then you can
use a progress bar as you move through the loop. Note that if you have 5
items in the loop there is no way to say how long any one of them might
take. The bar moves 1/5 of the way regarless of the amount of time - it is
just a way to show the overal progress through the counter.
--
Joe Fallon
Access MVP
paul said:
I have a query that runs for about 10 minutes. Can someone tell me how I
can tie a progress bar to the query to indicate the status of execution?
Thanks.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
