Solved

Problems with Access popup forms disappearing behind the main form

Posted on 2016-09-30
5
120 Views
Last Modified: 2016-10-01
Hello All

I created a bunch of forms for an Access database I created.  This problem does not happen all the time but when it does I have to shut down the whole Access program and restart it, losing what I did.

I have a Main Form that is maximized to take up the entire screen.  When a user clicks on a button a smaller form pops up in front of the Main.  Now most of the time this works fine, but ever so often the Popup Form blinks and then is behind the Main Form (the way I know this is when I right click on the Access icon on the toolbar and choose close the Main Form disappears and the Popup is on the screen briefly as the whole thing shuts down).

The Popup Form is set as Popup Yes and Modal Yes.  

Here is the line I use on the Main Form to call the Popup - DoCmd.OpenForm "Popup Small Quote Type Add", , , , , acWindowNormal

I cannot use acDialog to open the Popup because the users to not like the way it looks.

Help! :D

Thanks
0
Comment
Question by:alevin16
  • 2
  • 2
5 Comments
 
LVL 20

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 350 total points
ID: 41824456
the forms are layered then -- so if someone clicks the main form, it will come to the front.  Perhaps save the forms so the little one opens in the upper left corder and the main form slightly off that so the little one will always have a part of it showing. And perhaps when the little one opens, restore the view.

The properties may be being overridden by opening it as normal.
0
 
LVL 50

Assisted Solution

by:Gustav Brock
Gustav Brock earned 150 total points
ID: 41824549
Double-check this:

The Popup Form is set as Popup Yes and Modal Yes.  

because - by definition - there is no way to get a modal form behind another form - except for popping a new modal form.

/gustav
0
 

Author Comment

by:alevin16
ID: 41824859
Hey Everyone

Thank you all for the advice!  I took your advice gustav and I did do a doublecheck to see if they were set right and they were so I am wondering if there is some sort of odd bug in Access.  

I think I am going to have to try the first idea from Crystal of the Main Form not staying maximized and moving it slightly so that both forms can be gotten to.  I am not a big fan of that (I guess I am just anal and like the Main Form fully maximized) but if it keeps the users from having to shut the program (and of course yell at me :D) then I will do it.

Andy
0
 

Author Closing Comment

by:alevin16
ID: 41824861
Great comments as always from the experts!
0
 
LVL 20
ID: 41824875
you're welcome ~ happy to help
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

735 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