Link to home
Start Free TrialLog in
Avatar of wsturdev
wsturdevFlag for United States of America

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.
Avatar of Chuck Wood
Chuck Wood
Flag of United States of America image

Type this in the Immediate window and press Enter:
-chuck wood
DoCmd.Close acForm,"FormName"

Open in new window

Avatar of wsturdev

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
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Perhaps something is being triggered "Behind" the form.
But since the form is modal/dialog, this "failure" cannot be acted upon.
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

Obviously, this it is hard to troubleshoot with no sample code.

Perhaps another Expert has had this issue and can help you further...

JeffCoachman