Manipulating the Access 2007 User Interface

[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?

 

[Alex Dybenko]

Hi,
here it is:
http://accessblog.net/2010/01/how-to-hide-access-2007-office-button.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Jeanette Cunningham]

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

 

[Jeanette Cunningham]

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