Change -- Current Database Options - After Opening database - Access 2010
Posted on 2013-05-23
Version -->: Access 2010
Can I change database options to - show menus etc while the database is open?
eg --> Can I do a Ctrl S (I'm looking for VBA code) and show the Navigation Pane, Show Full Menus, Allow Default Shortcut Menus.
I can open the database with the shift key and see what I want.
I can Display Navigation Pane by using the below code
DoCmd.SelectObject acTable, "tbl_MyTable", True
A little more info
I set Current Database options so my users don't see some things I don't want them to see
* Display Navigation Pane = False
* Allow Full Menus = False
* Allow Default Shortcut Menus = False
I want a way in code to show the above without getting out of the database.
Thanks in advance for your help.