Progress bar question

[jospe1]

I would like to add a progress bar to my form to allow users to see progress on an updating function i created. The function runs a set of queries and takes about 10 minutes to complete, i would like to have a progress bar to let the user know that its still running and hasnt frozen up. any suggestions would be great.


Thanks in advance
gary

 

[c0i0nes]

There is an activeXcontrol for a progress bar in Access. Read about it on:

http://www.microsoft.com/accessdev/articles/Odesamp.htm#ODE

Get it by downloading actxsamp.exe from:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q165437&

Run it and convert the mdb if necessary to your version of Access.

Then have a lot of fun figuring how all the controls work - you have to see how the sample forms use code to link the controls to the interface and data via the controls properties etc.