p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Closing a message box "remotely"


Message #1 by "Lloyd Levine" <levinll@m...> on Fri, 7 Sep 2001 19:51:49
I'm trying to close a message box from within a macro that may come up when 

the main screen. I've tried using SendKeys, but that doesn't work. Does 

anyone have an idea on how to close a message box without user intervention 

?



Thanks !
Message #2 by Brian Skelton <brian.skelton@b...> on Fri, 7 Sep 2001 22:29:50 +0100
Hi Lloyd



I'm almost certain that you're not going to find a fix for this one. My 

understanding is that message boxes are 'Application Modal' windows. So, 

as soon as one of them pops up on the screen, the rest of your Access 

session just sits back and waits for the user to deal with it. No code 

will run, events are not handled - you can't even close the program down 

without having Windows be brutal about it!



You'll need to come at it from the other end and prevent the message 

from displaying in the first place.



-BDS



-----Original Message-----

From:	Lloyd Levine [SMTP:levinll@m...]

Sent:	07 September 2001 20:52

To:	Access

Subject:	[access] Closing a message box "remotely"



I'm trying to close a message box from within a macro that may come up 

when

the main screen. I've tried using SendKeys, but that doesn't work. Does

anyone have an idea on how to close a message box without user 

intervention

?



Thanks !

Message #3 by "Lloyd Levine" <levinll@m...> on Mon, 10 Sep 2001 13:51:36
In this case I'm putting up the message box in my startup form, but I need the ability to close 

it from elsewhere in my database.



> Hi Lloyd

> 

> I'm almost certain that you're not going to find a fix for this one. My 

> understanding is that message boxes are 'Application Modal' windows. So, 



> as soon as one of them pops up on the screen, the rest of your Access 

> session just sits back and waits for the user to deal with it. No code 

> will run, events are not handled - you can't even close the program down 



> without having Windows be brutal about it!

> 

> You'll need to come at it from the other end and prevent the message 

> from displaying in the first place.

> 

> -BDS

> 

> -----Original Message-----

> From:	Lloyd Levine [SMTP:levinll@m...]

> Sent:	07 September 2001 20:52

> To:	Access

> Subject:	[access] Closing a message box "remotely"

> 

> I'm trying to close a message box from within a macro that may come up 

> when

> the main screen. I've tried using SendKeys, but that doesn't work. 

Does

> anyone have an idea on how to close a message box without user 

> intervention

> ?

> 

> Thanks !

Message #4 by Walt Morgan <wmorgan@s...> on Mon, 10 Sep 2001 08:22:44 -0500
You may wish to consider setting the caption value of the form to indicate

some sort of message to avoid using a message box.



example:



    frmThisForm.Caption = "This is a message I want folks to see"

    frmThisForm.Refresh

or:



    using the statusbar for the same purpose



Walt



Message #5 by Brian Skelton <brian.skelton@b...> on Mon, 10 Sep 2001 16:55:56 +0100
How about replacing the message box with a form? You can make it look 

like a message box and, so long as you don't make it modal, you can 

control it programatically.



-BDS



-----Original Message-----

From:	Lloyd Levine [SMTP:levinll@m...]

Sent:	10 September 2001 14:52

To:	Access

Subject:	[access] RE: Closing a message box "remotely"



In this case I'm putting up the message box in my startup form, but I 

need the ability to close it from elsewhere in my database.

Message #6 by John Fejsa <John.Fejsa@h...> on Tue, 11 Sep 2001 09:04:52 +1100
Or use a standard popup form to display your message and then close the 

popup mesasage form in code, either from your main menu or from message 

box form timer event.



JohnF



>>> wmorgan@s... 10/09/2001 23:22:44 >>>

You may wish to consider setting the caption value of the form to indicate

some sort of message to avoid using a message box.



example:



    frmThisForm.Caption =3D "This is a message I want folks to see"

    frmThisForm.Refresh

or:



    using the statusbar for the same purpose



Walt






  Return to Index