Re: MS Access: Force Form with Data*** To Keep Focus When User Navigates Away -Stumped-

I had a couple of minutes this morning so fired up an Access 2000
machine and repeated the steps as before in 2007 with the same
results.

On May 30, 5:05 am, cc77le...@xxxxxxxxx wrote:
On May 29, 10:39 pm, lyle fairfield <lyle.fairfi...@xxxxxxxxx> wrote:



What version of Access?

In 2007, Northwinds, the wizard creates a continuous form based on
Employees, call EmployeesTest.

I set these properties:

DefaultView: Data***
Allow Form(and all the other but Data***) View: No.
Popup: Yes
Modal: Yes

In another form I create a Buttom, Command1 with this onClick Code:
Private Sub Command1_Click()
DoCmd.OpenForm "EmployeesTest", acFormDS
End Sub

The EmployeesTest Form opens; Nothing outside the EmployeesTest Form
is available. The EmployeesTest Form can be Maximized, Restored and
Resized using the handles in the bottom right-hand corner, even
Minimized which leaves the Access window essentially dead.

On May 28, 5:29 am, cc77le...@xxxxxxxxx wrote:

Ok.

What I want to do is:

Call up form2 from a button on form1.  Form2 is a data***.  I don't
want the user to be able to lose focus of this form2 until the
traditionally close it with the 'x' button.  Form2 must be sizeable.

It doesn't seem (haven't found a way) to make a Data*** Sizeable
Form be Modal and stay on top of all other windows until the user
closes the form by the 'x' button on the form.

Only other choice I have is to try to catch when the user tries to
take focus away from the form by clicking another area in access other
than form2.

The Form2's 'On Lost Focus' Event refuses to fire due to the nature of
how Access works (I've read).
This is because there are other controls on the form2 that could have
focus.
SO... I went to each of the controls (3 of them) on form2 and set
their 'On Lost Focus' Events.

I just need to figure out the right code to stick in those Events in
order to return (forcefully) the user back to the form2 that should
keep the focus until the 'x' button is pressed.

Any suggestions?- Hide quoted text -

- Show quoted text -

It's MS Access 2000 Lyle.  Will also see what I can do with what
you're saying.  Thanks.

.

Quantcast