Standard Window File Dialog causes Access to hang when App is closed

[robert d via AccessMonster.com]

I'm using the standard Windows File Open/Save dialog box in my app. I
downloaded the code available at

http://www.mvps.org/access/api/api0001.htm

Everything works just as it is supposed to, except that if this open
dialog window is left open and the user tries to exit the application, Access
hangs, and I have to Ctrl-Alt-Del to close Access.

Is there any way to force the Windows File Open/Save dialog box to open in
modal form, so that it would have to be closed first before the user could
try to exit the application.

Thanks.

 

[Albert D.Kallal]

Gee, that api runs model for me...

You can try and download my "shft key by pass" exmaple. It uses the api..and
it is model .....

You can find it here.try running it....and see what happens....

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[robert d via AccessMonster.com]

I did some additional testing and removed the existing File Open/Save Dialog
box (which I probably modified) and start again with virgin code from the
website referenced.

This problem appears to occur when I have the Windows File Open/Save Dialog
box open on top of an already opened modal form.

If both forms are open (the modal form and the dialog box on top of it), then
I am unable to close Access using either the control box or the menu. However,
if I close the modal form, which leaves just the dialog box displayed, and
then try to close Access the system hangs as described previously.

If the File Open/Save Dialog box is modal itself, I'm not sure why it allowed
me to close the modal form underneath it.

Thanks.

 

[Albert D.Kallal]

Making your form model should not matter.

Perhaps your form is also set to "popup", and it likely does not need to
be...

That code is downloaded and used a LOT, and I can't recall your problem.

 

[robert d via AccessMonster.com]

The problem was indeed that the form was both modal and popup. Setting the
form popup property to no solved the problem.

Thanks.