• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 941
  • Last Modified:

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.
0
gcgcit
Asked:
gcgcit
  • 3
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
you can also set to hide the NP from File > Options > current database
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

 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.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

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

Jim.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
gcgcitAuthor Commented:
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
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
 That was a VBA statement to be used in code.

  If your just going to run it in the Autoexec macro, you want the RunMenuCommand action with the command WindowHide.

Jim.
0
 
gcgcitAuthor Commented:
Worked thanks!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now