"In Progress" message box

G

Guest

Is it possible to display an "in progress" message while a function is
working, then turn it off when the function is complete?
 
D

Dirk Goldgar

Carol Giannini said:
Is it possible to display an "in progress" message while a function is
working, then turn it off when the function is complete?

Sure. Build it as a form, open the form when you start your function,
and close it when you exit the function. Depending on what the function
is doing, you may need to execute the DoEvents statement after opening
the form to make sure it gets fully displayed.
 
A

Albert D. Kallal

I have a nice box that looks VERY much like a windows progress bar (like the
ones you see during a download).

This box can run while you run something (and, it is can even progress by
its self).

Try downloading and running the "super easy word merge" here:
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

If you run the above...and look at the form...there is a "sample" button to
try and run the progress bar...
 
B

Bas Cost Budde

Albert said:
I have a nice box that looks VERY much like a windows progress bar (like the
ones you see during a download).

This box can run while you run something (and, it is can even progress by
its self).

Try downloading and running the "super easy word merge" here:
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

Hmm... neat.

I noticed the LinesOfCode on your page--did you ever check FindName and
FindCode on mine? They're under Tools
 
J

Jesper F

you may need to execute the DoEvents statement after
opening the form to make sure it gets fully displayed.

I've used me.repaint in order to update a progress form
(or the screen). Should DoEvents be used instead?
 
G

Guest

Albert - unfortunately, my network settings won't let me download this. If
you see this, could I prevail upon you to send me the file via e-mail?
(e-mail address removed). Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Progress BAR 2
Daily Task Tracking 1
VBA - Form Progress 4
Excel Progress Bar Showing Progress of Month 0
Progress Meter 8
Connection String - Progress Database 0
Progress Bar for Download 13
Percent completed 2

Top