Solved

Lock Form Focus

Posted on 2004-09-29
4
272 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 100 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 65

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

809 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