Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
displaying message while executing procedure 2
- Thread starter sfenx
- Start date
-
2
- #2
I like to use a special no-border popup form to which I pass the message via OpenArgs:
DoCmd.OpenForm "InfoBox", , , , , , vbCrLf & "Please wait..."
DoEvents
The DoEvents helps ensure that the form has a chance to appear before your subsequent code starts eating up all the CPU time.
When you're done, just close it with:
DoCmd.Close acForm, "InfoBox"
You can even get fancy and let the InfoBox form figure out how to center the message vertically.
Rick Sprague
DoCmd.OpenForm "InfoBox", , , , , , vbCrLf & "Please wait..."
DoEvents
The DoEvents helps ensure that the form has a chance to appear before your subsequent code starts eating up all the CPU time.
When you're done, just close it with:
DoCmd.Close acForm, "InfoBox"
You can even get fancy and let the InfoBox form figure out how to center the message vertically.
Rick Sprague
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question