Hi all,

I have a VB app that runs an MS Access macro in the background. The Access macro runs several queries. I want to show a progress bar on the VB form so that it shows how much longer it takes for the macro to be completed. How can I set the max setting?

Please don't tell me to run the queries in VB, because that's just not how I want to do it. Everything is all set in Access, I'm just creating the front end for it.

FYI, the macro runs for about 15-30 minutes until it's finished.

Any help is greatly appreciated. Thanks a lot.

Martin