Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to use either macro's or VBA to programatically control the Access Navigation Pane (i.e. hide and unhide it). I've found plenty of resources to hide the Navigation Pane (e.g. RunMenuCommand>WindowHide, Display Navigation Pane checkbox), but I haven't been able to find a solution that will let me hide and unhide the pane.

Ideally I'd like to have the Autoexec macro hide the Navigation Pane, and then have a button on a user field that can unhide and then re-hide it. I've tried RunMenuCommand>WindowUnhide without any success. Again, either macro or VBA would be fine for a solution.

EDIT: Right now I'm using the Autoexec macro to NavigateTo>MinimizeWindow and then a button click to toggle between NavigateTo>WindowMaximize and >WindowMinimize (syntax may be off a bit, I don't have it open currently). I'd prefer to Hide/Unhide to minimize the likelihood of accidental changes-it would take a conscious effort to open the pane-not just random navigation by an inexperienced user. FWIW, this is more about accessibility to it and not really a security issue.

share|improve this question
    
Can you share the of code you're using now? – CharlieRB May 17 '13 at 12:49
    
Does it have to be hidden or can it be minimized? It will be much easier to minimize and maximize the window. – CharlieRB May 17 '13 at 13:46

You must log in to answer this question.

Browse other questions tagged .