Timed message box?

[Guest]

Hi,

I have a macro running a set of queries and I would like to add some
messages that indicate which query is being run at the present time. I tried
using the MsgBox function and that almost does the trick except the user has
to click on the "OK" button to move on from the message.

I'm looking for something that doesn't require the user to click on the OK
button and will go away after the query has finished running.

 

[strive4peace]

Hi Jim,

form to give a message to the user to wait while the program runs...

create a form
Name --> PleaseWait
Popup --> yes
Modal --> no
Navigation Buttons --> No
Dividing Lines --> No
RecordSelectors --> No

with a label
Name --> Msg
Caption --> Please Wait...

when you want to display it

'~~~~~~~~~~~~~~~~~~~~`
DoCmd.OpenForm "PleaseWait"
'~~~~~~~~~~~~~~~~~~~~`

periodically, if you want to update the message, you can do this:

'~~~~~~~~~~~~~~~~~~~~`
Forms!PleaseWait.Msg.Caption = "Message"
DoEvents
'~~~~~~~~~~~~~~~~~~~~`


then, when your program is done

'~~~~~~~~~~~~~~~~~~~~`
DoCmd.Close acform, "PleaseWait"
'~~~~~~~~~~~~~~~~~~~~`


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*