status update (1 Viewer)

[VBAhole22]

I have a function that loops through a rather large table performing operations. HOw can I get a meter on the screen to update the user as to how much progress is being made in the loop?

 

[David R]

Best solution: go to the 'search' link, enter 'progress meter' in the text to search for box, and all Forums. I found at least 16 entries, and there may be more under 'progress bar'. One of them should suit your skill level and needs.

Leave off the single quotes, of course.

HTH,
David R

[This message has been edited by David R (edited 01-23-2002).]

 

[Pat Hartman]

I think you will find that if you can do the update in an update query it will be substantially faster than from code in a loop.