Maximize Access

[Guest]

I want to run a macro or module that automatically maximizes "ALL"of Access
when I open my db. Right now I have a macro (autoexec) that starts up when I
startup my db that maximizes everything inside of access, but is it possible
to maximize Access itself?

Hopefully this makes sense

 

[Steve Huff]

Paste the following code in a module and call the function MaximizeAccess to
Maximize Access:
'//Start code-----------------------------
Declare Function ShowWindow Lib "User32" (ByVal Hwnd As Long, ByVal nCmdShow
As Long) As Long
Global Const SW_SHOWMAXIMIZED = 3

Function MaximizeAccess()
Dim Maxit%
Maxit% = ShowWindow(hWndAccessApp, SW_SHOWMAXIMIZED)
End Function
'//End Code ----------------------------

--Steve Huff

 

[Van T. Dinh]

In VBA code, you can use the statement:

DoCmd.RunCommand acCmdAppMaximize

to maximize the Access Application window.