create a pause between events, not using timer()

[Gregorio]

Hello.
I'd like to pop up a form that provides a message to the user while code
continues to run in the background. At present, the routine that calls the
form is so hyper it launches into the rest of the code and pegs the CPU with
queries before it can even allow this "informational" form to be painted. So
I'd like to create a delay of a few seconds to allow this informational form
to paint, and then close.

A MsgBox won't work as this would require user to hit ok before code
continues to run.

Suggestions maestros? - Greg

 

[RuralGuy]

Hello.
I'd like to pop up a form that provides a message to the user while
code continues to run in the background. At present, the routine that
calls the form is so hyper it launches into the rest of the code and
pegs the CPU with queries before it can even allow this
"informational" form to be painted. So I'd like to create a delay of a
few seconds to allow this informational form to paint, and then close.

A MsgBox won't work as this would require user to hit ok before code
continues to run.

Suggestions maestros? - Greg

Hi Gregorio,

Have you looked at:

http://www.mvps.org/access/api/api0021.htm

HTH

 

[Albert D.Kallal]

Grab my super easy word merge.

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Try running a word merge, and note how the please wait dialog box pops up.

Also, try pressing the button called "progress bar demo"

The progress bar demo uses a timer event..but the word merge does not.

Try them both..and then examine the code for the progress bar...