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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Msgbox not required

Status
Not open for further replies.

MitchJP

MIS
Feb 17, 2004
43
US
Hello,

Anyone know how I can create a msgbox in Access that does not require a user response? I have some code that runs, and as a part of it it pops up a message to the user. Problem is that the code haults until the user responds. I do not want it to halt.

Is there any other kind of MsgBox, such as a warning or alert, that does not require a user response?

Thanks!
MitchJP
 
There is a way to do this that involves and bunch of VBA coding and some API calls.

You can mimic it though, by creating a small form with your message, opening this instead of the message box, and using the ontimer/timer events to close the form in a second or two...

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
 
Excellent advice! I'll try that.

I sawe the FAQ regaridng the API use after I posted this, but I like the open/close form option better.

Thanks!
MitchJP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top