Log in

View Full Version : Navigation pane in Access 2010



Butcherk
02-28-2014, 01:59 AM
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!

Butcherk
02-28-2014, 03:06 AM
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.

Butcherk
02-28-2014, 03:29 AM
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.