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!
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!