Solved

Problems with Access popup forms disappearing behind the main form

Posted on 2016-09-30
5
72 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 19

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 49

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 19
ID: 41824875
you're welcome ~ happy to help
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Modern/Metro styled message box and input box that directly can replace MsgBox() and InputBox()in Microsoft Access 2013 and later. Also included is a preconfigured error box to be used in error handling.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
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.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

786 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