How to create a progress bar for a batch of long runnning queries

[ToyFox]

I have a series of queries that I run from a function.
Its just a bunch of Docmd.Openquery statements....but I would love to include a progress bar for the entire set of queries in this job. I can do it within a DO LOOP, but is there a way to create a progress bar from something like this.

 

[niteraven]

I have used this one before not sure if this is what you are looking for. It is a video from Datapig.

http://datapigtechnologies.com/flashfiles/progressbar.html

Good Luck
Raven

 

[alvechurchdata]

You can make a very simple progress bar by having a row of square images in a row (one for each query),start with them all invisible and make them visible one by one as each query completes. If each image has a nice 3D shaded effect then you can get what looks like a very professional bar.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[1DMF]

You could use the inbuilt syscmd progress meter

You can see it implemented in my FAQ for FTP'ing faq705-5904

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!

 

[ToyFox]

Thanks everyone...