Progress Bar Freezes (Access 2003)

Topic

New Reply

I’ve setup a common form (F_ProgressBar) that includes a text box and a Progress Bar (add-in from ‘More Controls’). When I run a piece of code, I call this form and set the progress bar to the percent complete when looping through a recordset. I have a few pieces of code that can take up to 10 minuts to run so I want to go to another application to do other work, however when I do, the progress bar freezes and from that point forward I’m unable to find out where I’m at in the process. Is their any way to refresh this or keep the progress bar from freezing when I move to another application?

As an FYI, I have dual monitors and keep Access up on one and do other work off the other.

Thanks in advance for the help.
Drew

Reply | Quote

Replies

Insert one or more lines

DoEvents
Me.Repaint

in the loop

If the code runs from another form, use

Forms!F_ProgressBar.Repaint

instead of Me.Repaint.

Reply | Quote

Works perfect. Thank you!

Reply | Quote