Solved

Problems with Access popup forms disappearing behind the main form

Posted on 2016-09-30
5
224 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
[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
  • 2
  • 2
5 Comments
 
LVL 21

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 51

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

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
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.
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.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

627 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