Question how to use progress bar

marianne

Registered User.
Local time
Yesterday, 21:07
Joined
Mar 26, 2009
Messages
327
hi, I know some of ms access databasing. but I would like to know how to use the progress bar.

for example I am going to export a query to an excel file. but this file is so voluminous that it takes time that I want to show a progress bar for it.

can someone help me on this? thanks.
 
A progress bar needs to be initialised with the min and max values, then it needs to be updated periodically. So cannot be used the way you want to use it, as you cannot break into a query to determine how much work has been done to update the progress bar.

However queries do use the progress bar automatically.
 
That's right - if you want a progress bar in a form or dialog, you'd have to write some code to iterate through the query records inside a loop, creating the file as you go (either using Excel automation, or by outputting textual lines with print# to a .csv file that will open into Excel)
 
but exporting a single query to an excel table can onyl take 20-30 secs even for a very big file

you can put the hourglass on and off


docmd.hourglass true

docmd.transferspreadsheet etc....

docmd.hourglass false
 

Users who are viewing this thread

Back
Top Bottom