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
