14 hours ago: Power and Internet are out in my office due to Hurricane Ian. Click for details.
 
Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
 
Home > Forums > Access
Access Forum


Back to Access Forum
 

Keep a form in the back Upload Images   Link  
Terry Heaton 
12 days ago
Hi Richard. I have a main form that sits in the back and cover the whole screen. It does have some functioning button that open other form on top. Those forms do not cover the whole screen. The main form at that point becomes a background. However, any time I or employee accidentally click on the background (main form) all other form disappear and the only way to get them back is with the ribbon (which I do not want them to have access to.)

docmd.RunCommand.acCmdSendToBack will only work when the form is in design mode. Is there any way to bypass or ignore the click event or even to force to form to stay in the Background
Adam Schwanz
12 days ago
It does that even you right click it, go to position, put send to back. Then take the front form right click it, go to position, bring to front?
Terry Heaton
12 days ago
Adam, You don't get an option to send anywhere from the main form's context menu (Main Form is borderless and not resizable by design) for the most part the main form acts like a Background - except for buttons that open other forms. Those open windows are designed to cover all button on the main form. This has worked for along time until I decided I wanted to open a Contact (Rolodex) form at any time (from a button on the main form). When I click on that button the customer form or any other form for that matter disappears. For security reason I do not want to teach employees how to use ribbon bar
Kevin Yip
12 days ago
In form properties set "Modal" to Yes, and the form will always be on top, even if you click on the background or anything else.  Only after you close the form can you click anything else.

If you can't use modal forms, setting focus on the forms hidden on the back will bring them back in front:

Forms![MyFormAtBottom].SetFocus
Richard Rost
5 days ago
If you have a form in the background that you don't use for user interaction but you need it for functionality or values, then open it hidden. You can still use it in your code. I've got a video coming up on this soon.
Add a ReplyUpload an Image


Back to Access Forum Comments
 

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

Check out these other pages that may be of interest to you:

9/27/2022Report Border
9/26/2022First Day of Month
9/23/2022Before Update
9/22/2022Synchronize Subforms
9/21/2022InputBox
9/20/2022Link Master Fields
9/19/2022DateSerial
9/18/2022Sequential Annual Coding
9/16/2022Scope
9/15/2022Resize Forms
 
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn