Maximize Access Window

[hmongie]

Hope any of you can help me here.

What I am trying to do is when the database is opened, it will maximize into the whole screen. This will also cover the windows' start taskbar also. I tried the below but the taskbar still stays on top of the access window. Any help you can give, thanx.

DoCmd.RunCommand acCmdAppMaximize

 

[Kevin_S]

You could just hide the taskbars on startup and then use your DoCmd.Maximize function. Go to the the Tools -- Startup menu and uncheck allow menus, allow toolbars, etc... This way next time you open the app the toolbars will be hidden. There is also some code available in this forum posted by GHudson I believe that provides another way to programmically disable the toolbars...

HTH,
Kev

 

[mdemarte]

autoexec

I picked this up from this forum. I create a macro and call it AUTOEXEC. In the macro, I have only a few lines.

Open Form Switchboard
Maximize

I don't put anything in Tools, Startup, cause Access runs this macro when I open the database. Of course, if I needed to set any values, I would do that first. Also, you could have it Open Form some other form than the Switchboard, too.

 

[ghudson]

What I am trying to do is when the database is opened, it will maximize into the whole screen. This will also cover the windows' start taskbar also.

You need to set the forms PopUp = Yes and the Modal = Yes properties. Then in the forms OnOpen event you need to just maximize the form using this command...

Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub

That will "fill" the screen with your form but it will not hide the Windows task bar if the users PC has it locked. You would not want to hide their task bar unless you really wanted to pi$$ them off.

Search this forum for the key words "Close X" and the user "ghudson" for I have posted code that will disable the application X in the upper right corner that will prevent a user from closing your application unless they click the magic button on your form to close [exit] the application.

That is really not an efficient way to format your forms and application. But that is a personal choice. Search the forum [as Kevin_S suggested] for the keywords "tool bars" and user "ghudson" for I have posted code to hide the menu bars, tool bars, db window, etc.

HTH

 

[hmongie]

thanx.. I'll look those up...