Progress bar

[Zurn]

while executing my code I want to make waiting less boring by indication
progress with a progress bar.

My code does different things: getting values, putting into labels,
visualising labels. It is many code to run through so it takes a while. What
will I use best for this problem?

I saw already the topic on this forum:
1. Go to MVP Sandra Daigle's site for some working examples:

http://www.daiglenet.com/msaccess.htm
(Download Progress Meter 2.0)

2. For a detailed visual walk-through guide, see this link:

http://www.datapigtechnologies.com/flashfiles/progressbar.html

But I don't understand how I can use it. It's all concerning queries,
iterations...
Or do I have to estimate the iterations (see 1) for each code run?
And what does DoEvents do?

A lot of questions,
maybe someone has already encountered the right answer?

Zurn

 

[JimS]

There's also a SYSCMD method, that provides a progress bar, though in all
cases you must know your goal in order to show your progress.... <If you
don't know where you're going, any old road will take you there...>