Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.