Manipulating the Access 2007 User Interface

  • Thread starter Thread starter David C. Holley
  • Start date Start date
D

David C. Holley

1) How can I programically eliminate, hide or minimize that damned Ribbon?

2) How can I hide the Navigation bar?

In short, how can I lock users out from accessing the underlying objects
unless I want them to have that access?
 
1) In VBA add the line to HIDE the Office Button and Ribbon ...

DoCmd.ShowToolbar "Ribbon", acToolbarNo

Use ...

DoCmd.ShowToolbar "Ribbon", acToolbarYes

to turn them back on.



2) DoCmd.LockNavigationPane True
This prevents users deleting or renaming objects in the Navigation Pane. We
do not include this by default, as it could confuse and frustrate existing
developers. To unlock the Navigation Pane again, open the Immediate Window
(Ctrl+G) and enter:
DoCmd.LockNavigationPane False


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Here is more code for the nav pane.

To hide the NavPane

Public Function HideNavPane() As Byte
DoCmd.SelectObject acTable, "MSysObjects", True
DoCmd.RunCommand acCmdWindowHide
End FunctionTo unhide the NavPane ...

To show the NavPane

Public Sub UnHideNavPane()
DoCmd.SelectObject acTable, "MSysObjects", True
End SubPlease note that the same code can be used to Hide/UnHide the
database window in A2003 and prior



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Back
Top