Another Progress Bar

[Big_Si]

Hi

Yes its yet another question about how to get a progress bar working correctly. I have been looking arround the forum for some time and am struggling to decide if what I am after is even possible.

When the database is opened a query run to find new records updated since the last time it was used. As the query is working with linked AS400 tables via an ODBC connection it can prove to be quite time consuming and in some cases the user believes the DB to have frozen. The Access status bar seems to reflect the query progress correctly but due to where it is it tends to go unnoticed.

If possible I would like to show a progress bar in the centre of the screen whilst the query is running. I have attempted to do this in several different methods and needless to say without much luck. I have encountered a variety of results from progress bar not updating until the query has completed to the form not opening atall.

Can anybody help please?

Cheers

 

[Mr. B]

AFAIK, there is no way to tap into the information that Access uses to show the status bar at the lower left of the Access Window and have your own progress bar display the same progress. You might try putting a message in the middle of your form, reminding your users to watch the "Status Bar" to see the progress.

Someone else may have a better idea.

 

[Big_Si]

Well atleast it has answered the question. Thanks for the quick relpy Mr B.

 

[Mr. B]

Let's see if anyone else has any other ideas.

 

[gemma-the-husky]

the progress bar works by

a) having a 100% value for the bar (say you have 250 items)
b) updating the bar for each item

in order to do this, you need to be able to count how many items you have processed (out of the 250). now if this progress is done by running a query, you have no way of getting the progress inforamtion, so you cant do it. If you are processing a recordset, then clearly it becomes relatively easy to do.

the only things you could do are
a) put an hourglass up
b) but a formup to let the user know it will take a while, and close this after a few secs, with a timer - this avoids the user having to click buttons