Hi,

I have a form that generates reports for an end user by clicking a button. However, the process can take up to or a little more than half an hour. What I need is some form of timing mechanism on the screen, a sort of "Estimated time remaining: " display.

Currently in my code, I have labels that are made visible as each of the 8 categories of reports are completed. (It is all in a large for loop, so at the end of each loop the code looks something like lblCategory1.visible = true ...which displays "Category 1 reports Done!") However, even this is not updating. It basically just ends up waiting till the whole code is done, and then all 8 of the labels become visible at once, which defeats the purpose.

I should add, during this process, an Excel file is opened (with its visible property is set to false), where the reports are pasted. I don't know if this should affect anything on the view of the form itself.

Please advice!

Thank you,
Kriti

The issues is that the form is not getting a chance to refresh since the loop is so busy. Try add a DoEvents like this:

blCategory1.visible = true
DoEvents



Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com

hey boyd,
thanks for replying...
what would the DoEvents do?
kriti

DoEvents temporarily hands off control to the system so it can do some of what it needs to do (screen updates, etc.) before it hands control back to your code.

-Phil-