Maximize Access application

[mutidjo]

hello,
i have a button on my main menu which is coded so that when it is clicked then it opens another access database. It does open the database, but the application is minimized and found on the bottom of the screen (taskbar?), so the use has to click on it to maximize the screen.

Has anyone run into this problem before. I just want the user to be able to click on the button, and the second Acceee mdb file to open maximized.

Any help is appreciate.

Much thanks!

 

[binky]

I have had the same problem calling Access from VB. I tried using the .Maximize method. Maybe it would work in Access. (It doesn't in VB)

Ken

 

[Newposter]

Set the Properties of the form that opens first (assuming you do launch a Form) to On Open -> DoCmd.Maximize

 

[emuti]

I found the following solution, hope it helps:

Dim retval As Double
retval = Shell("MSACCESS " & "[Fil path]", 3)

The "3" maximizes Access and places it in focus.