Solved

Re-hide navigation pane

Posted on 2014-12-15
1
125 Views
Last Modified: 2014-12-15
I know F11 un-hides the navigation pane.  F11 again collapses the pane.  But is there a way to TOTALLY hide the pane, not just collapse it with a hotkey?
0
Comment
Question by:SteveL13
1 Comment
 
LVL 35

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40501293
Under File/Options/Current Database is an option to hide it permanently.  Unfortunately, certain fairly common actions such as importing/exporting a spreadsheet will pop it open again and even though I have found code that purports to tuck it away again, I can't get it to work.  Best case is it is reduced to a vertical bar.  The solution that works best is renaming the database to .accdr.  That tells Access to pretend to be the runtime engine.  Since the runtime doesn't allow design view, it doesn't allow the nav pain (sic) to pop open.  Of course, you also loose the right-click menus and you need to be very careful about error trapping or the users will be summarily dumped out of the app on unhandled errors.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBA Access 2016 syntax 6 41
Modal form 11 29
ACCESS 2010 - VBA - generic Table Open Button - Code 7 20
Report with several filters - Issue with query? 3 23
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question