MInimize Application and set focus

[crimedog]

I have a Database that Opens to a Form.
The On Open event has

DoCmd.RunCommand acCmdAppMinimize

The form has 2 textboxes (For Authentication) I want TextBox TxtUsername to be the focus so user can just start typing.
What currently happens: The Minimize command works - but the form is hidden behind whatever App the user has open (outlook IE etc...)
If the user has anything open the form (Pop up & Modal) shows but it is not Active Or does not have the focus.
I added :

Forms("0Frm_LogIn").SetFocus
Me.TxtUserName.SetFocus

In the Open Event - then moved it to the Load event (when that did not work)

I have also tried to add a Splash form that has an On Open event to minimize Application and On timer event that Opens form 0Frm_Login - leaving the On Load events It works right if I am in Access. But if I start the Database directly it does not work.

have a thread n the Access forum - prior to trying the Splash screen - and it is probably better in the Forms folder.

[davegri]

I don't understand how the user can just start typing when the form is minimized.
As far is being behind other open apps, if the form is minimized you can't see it even with NO other apps on the screen.

That being said, if the form is not popup, you can use this in the form open event to set the focus:

Me.TxtUserName.SetFocus
DoCmd.RunCommand acCmdAppMinimize

The focus will be set to the login username if the user brings the form up visible from minimized.

[crimedog]

sorry about the long time - been away - the form is not minimized it is a pop up - the application is minimized so you can't see Access toolbars and window. Works great - but the form while not minimized will be behind anything else that is open