Consulting

Results 1 to 3 of 3

Thread: Navigation pane in Access 2010

  1. #1

    Navigation pane in Access 2010

    Hello,

    This is my first post on the forum, so first of all I'll say hi!
    Getting down to business: I'm developing an Access 2010 application with separate front-end and back-end and I'd like to hide the navigation pane of the front-end from users.
    I've tried several options found here and there:

    1. Go to File/Options/Current Database/Display Navigation Pane and I did uncheck it: it did not work (the navigation pane still appears at startup).
    2. At startup, a piece of code is executed. I tried to add the following commands:
    a. DoCmd.SelectObject acTable, "OneTableInTheNavigationPane", True
    DoCmd.RunCommand acCmdWindowHide
    b. DoCmd.LockNavigationPane True
    c. DoCmd.ShowToolbar "Ribbon", acToolbarNo
    d. CurrentDb.Properties("StartUpShowDBWindow") = False
    e. Combinations of the above

    Obviously, the reason I am here is that nothing worked so far.

    Is there some piece of information I'm missing that would prevent me from hiding (and locking) the navigation pane?
    Thanks for your help!

  2. #2
    Hi there,

    OK, for those who might be looking for an answer here, I did find the reason why the left panel kept showing up. It shows up everytime you link a new table. So make sure you hide the panel everytime a new table is linked to your DB.

  3. #3
    By the way, this solution is really not satisfactory. It tends to close all the open forms whenever I link a new table. This is extremely annoying. Anybody found a better way than the DoCmd.RunCommand acCmdWindowHide?
    Best regards.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •