Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to close a frozen modal dialog form

Posted on 2009-07-13
8
Medium Priority
?
922 Views
Last Modified: 2013-11-27
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.
0
Comment
Question by:wsturdev
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 16

Expert Comment

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

Open in new window

0
 
LVL 1

Author Comment

by:wsturdev
ID: 24842145
When I do that, I get "Compile Error.  Expected: End of Statement"
0
 
LVL 16

Expert Comment

by:Chuck Wood
ID: 24842170
1. Did you use the name of the form for "FormName"?
2. Did you compile your code and save it before testing?
-chuck wood
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 24842349
You have to use full syntax:

DoCmd.Close( acForm,"FormName")

0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24847554
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
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24847610
Perhaps something is being triggered "Behind" the form.
But since the form is modal/dialog, this "failure" cannot be acted upon.
0
 
LVL 1

Author Comment

by:wsturdev
ID: 24849046
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
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24850535

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

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

JeffCoachman
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question