Link to home
Start Free TrialLog in
Avatar of gcgcit
gcgcit

asked on

Minimize Navigation Pane on Autoexec?

In Access 2010 - how do you make a database have the lefthand Navigation Pane minimized on load of the applicatoin?

I assume I could do this in the autoexec but unsure how to.  Please advise.
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

you can also set to hide the NP from File > Options > current database

 Do a DoCmd.RunCommand acCmdWindowHide at startup or in the autoexec macro (probably a better place as you must issue the command before anything becomes visible).

Jim.

 BTW, a F11 with sendkeys from code will hide/unhide the window as well.

Jim.
Avatar of gcgcit
gcgcit

ASKER

JDettman - on the autoexec I could only find "RunCode" not "RunCommand" I got this error:

Micros Access cannot find the name 'acCmdWindowHide' you entered in th eexpression.

See screenshot of my autoexec macro
ee-autoexec.JPG
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gcgcit

ASKER

Worked thanks!