wsturdev
asked on
How to close a frozen modal dialog form
I have several apps in Access 2007 that have a number of modal dialog forms. When I am testing and trying to simulate user conditions and something in the modal dialog form fails, I am always forced to Ctrl-Alt-Delete and force quit the application.
Is there some command or shortcut that will allow me to close such a modal dialog while in an ACCDB so that I can continue my testing? I can successfully do Ctrl-G and get into the immediate window, but then cannot figure what to do. It seems like this should be a simple process, but I have never been able to figure out how to handle it.
Is there some command or shortcut that will allow me to close such a modal dialog while in an ACCDB so that I can continue my testing? I can successfully do Ctrl-G and get into the immediate window, but then cannot figure what to do. It seems like this should be a simple process, but I have never been able to figure out how to handle it.
ASKER
When I do that, I get "Compile Error. Expected: End of Statement"
1. Did you use the name of the form for "FormName"?
2. Did you compile your code and save it before testing?
-chuck wood
2. Did you compile your code and save it before testing?
-chuck wood
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
wsturdev,
1. <something in the modal dialog form fails, I am always forced to Ctrl-Alt-Delete and force quit the application.>
"Something" fails?
Can you be a bit more specific?
I use Modal Dialog boxes in Access 2007 and they close with impunity.
2. Can you post some of your code that generates this mysterious failure, and state what line it fails on?
3. Clearly define what you mean by "modal dialog form".
Modal and Dialog are two separate, but related properties
Thanks
JeffCoachman
1. <something in the modal dialog form fails, I am always forced to Ctrl-Alt-Delete and force quit the application.>
"Something" fails?
Can you be a bit more specific?
I use Modal Dialog boxes in Access 2007 and they close with impunity.
2. Can you post some of your code that generates this mysterious failure, and state what line it fails on?
3. Clearly define what you mean by "modal dialog form".
Modal and Dialog are two separate, but related properties
Thanks
JeffCoachman
Perhaps something is being triggered "Behind" the form.
But since the form is modal/dialog, this "failure" cannot be acted upon.
But since the form is modal/dialog, this "failure" cannot be acted upon.
ASKER
Jeff,
I use "modal dialogs" a lot also, and once I get the code perfected, they work well and consistently.
I am talking about while I am in the middle of developoment and still perfecting the code (sorry, I am not quite like those Papermate Pens... I don't write [perfect code] the first time, every time.).
I cannot be specific about what fails. The failures are not "mysterious", and in fact, they do not matter in this case, because I will eventually write correct code.
I was just asking a general question about how to get out of a "modal dialog" that has had some kind of failure in its code that has sent it into Debug Mode, and from which I cannot continue. I cannot bypass the offending statement and thus cannot get the form displayed completely enough so that I can then click the Cancel button and close it.
The "modal" property of the form is "No". I open the form in this way:
Dim stDocName As String
stDocName = "Dialog_Blah_Blah_Blah"
DoCmd.OpenForm stDocName, acNormal, , , , acDialog
The code in the calling form pauses processing until the "modal dialog" form is closed and control is returned to the next statement after the calling statement, and while the form is open, no action can be initiated by a user outside the form. Eventually, the user must do something (e.g. click an Okay button or a Cancel button) to dismiss the "modal dialog" and allow processing on the calling form to continue.
I have always called such forms "Modal Dialogs". Forgive me if I have used incorrect terminology.
Bill
I use "modal dialogs" a lot also, and once I get the code perfected, they work well and consistently.
I am talking about while I am in the middle of developoment and still perfecting the code (sorry, I am not quite like those Papermate Pens... I don't write [perfect code] the first time, every time.).
I cannot be specific about what fails. The failures are not "mysterious", and in fact, they do not matter in this case, because I will eventually write correct code.
I was just asking a general question about how to get out of a "modal dialog" that has had some kind of failure in its code that has sent it into Debug Mode, and from which I cannot continue. I cannot bypass the offending statement and thus cannot get the form displayed completely enough so that I can then click the Cancel button and close it.
The "modal" property of the form is "No". I open the form in this way:
Dim stDocName As String
stDocName = "Dialog_Blah_Blah_Blah"
DoCmd.OpenForm stDocName, acNormal, , , , acDialog
The code in the calling form pauses processing until the "modal dialog" form is closed and control is returned to the next statement after the calling statement, and while the form is open, no action can be initiated by a user outside the form. Eventually, the user must do something (e.g. click an Okay button or a Cancel button) to dismiss the "modal dialog" and allow processing on the calling form to continue.
I have always called such forms "Modal Dialogs". Forgive me if I have used incorrect terminology.
Bill
Obviously, this it is hard to troubleshoot with no sample code.
Perhaps another Expert has had this issue and can help you further...
JeffCoachman
-chuck wood
Open in new window