"In Progress" message box

C

Carol Giannini

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?
 
C

Carol Giannini

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?
[email protected]. Thanks!
 
H

hughess7

I am trying to do this, I have opened a form before executing an append query
but it doesn't display fully. I tried this website to look at your example
but it does not appear to be a valid url. Is it still available?
 
Top