Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Lock Form Focus

Posted on 2004-09-29
4
Medium Priority
?
280 Views
Last Modified: 2006-11-17
Hi,

The database we've created uses pop-up forms for some of its functions. Unfortunately some parts of the database will not work correctly if a user was to click on a form below the form that was just popped up. Is there anyway to lock the focus of the database on a current form?

Thanks,

James
0
Comment
Question by:jamoparisi
  • 2
4 Comments
 
LVL 15

Accepted Solution

by:
Colosseo earned 400 total points
ID: 12180748
Hi James

When you open the pop-up form you can set the window mode to acDialog to lock the focus on it.

for example DoCmd.OpenForm "frm_Popup", , , , , acDialog

will open the form frm_Popup and lock the focus on it until it is closed

HTH

Scott
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 12180828
Colollseo is right.  Also, from within a form you can set the .Modal = True property for the same effect.
0
 

Author Comment

by:jamoparisi
ID: 12181282
Perfect!
0
 
LVL 15

Expert Comment

by:Colosseo
ID: 12181296
Glad it worked

Cheers

Scott
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

926 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