Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / May 2005

Tip: Looking for answers? Try searching our database.

closing msgbox in vba code

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Stephen Haley - 26 Apr 2005 12:47 GMT
I am stuck
I have developed an access app wich under certain circumstances will display
a msgbox using the standard msgbox function. I am now trying to implement
timers for the application as a whole so that it is automatically closed if
the user does nothing for 80mins. The problem I have is that I cannot
sucessfuly use application.quit if a msgbox has currently got the focus. Is
there anyway I can close it from within the vba timer module? I suspect this
may need an api call ie enumerate child windows etc but how do you tell that
a msgbox has currently got the focus and what the hwnd is?

thanks in advance
stephen
Brainlord Mesomorph - 26 Apr 2005 13:33 GMT
If I had this problem,  Id use a custom form instead if msgbox.

>I am stuck
>I have developed an access app wich under certain circumstances will display
[quoted text clipped - 8 lines]
>thanks in advance
>stephen
Stephen Haley - 27 Apr 2005 08:36 GMT
will remember for next time but not an option here
Thanks for the help - have now managed to put together a string of apis that
deal with it. Closing boxes with the red cancel cross enabled was reasonably
easy but had some problems with the vbyesno as they have no cancel but
eventually sorted that with the usual mishmash of various peoples offerings.
Will post the resultant here if anyone is interested
rgds
stephen

> If I had this problem,  Id use a custom form instead if msgbox.
>
[quoted text clipped - 15 lines]
>>thanks in advance
>>stephen
Jay Jacobs - 24 May 2005 23:15 GMT
I would be interested in how you fixed this.  I have just ran across the same
issue with an app that has many msgboxes and a 7 minute system timer.
TIA
Jay

> will remember for next time but not an option here
> Thanks for the help - have now managed to put together a string of apis that
[quoted text clipped - 24 lines]
> >>thanks in advance
> >>stephen
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.