Access 2007 Interface

[Djblois]

I would like to use code to turn on and off these features:

1) full menus (ribbon - all commands)
2) Navigation Pane
3) Tabbed Documents

How do I do this with VBA?

 

[gbnz]

Code to turn on and off the Ribbon:

'on
DoCmd.ShowToolbar "Ribbon", acToolbarYes
'off
DoCmd.ShowToolbar "Ribbon", acToolbarNo

Code to open and close the Navigation Pane:

'to hide the navigation pane
        DoCmd.NavigateTo "acNavigationCategoryObjectType"
        DoCmd.RunCommand acCmdWindowHide
'to show the navigation pane
        DoCmd.SelectObject acTable, , True

Tabs are discussed here:
http://office.microsoft.com/en-us/access-help/show-or-hide-object-tabs-HA001229281.aspx

Good luck

 

[Djblois]

Code to turn on and off the Ribbon:

'on
DoCmd.ShowToolbar "Ribbon", acToolbarYes
'off
DoCmd.ShowToolbar "Ribbon", acToolbarNo

Code to open and close the Navigation Pane:

'to hide the navigation pane
        DoCmd.NavigateTo "acNavigationCategoryObjectType"
        DoCmd.RunCommand acCmdWindowHide
'to show the navigation pane
        DoCmd.SelectObject acTable, , True

Tabs are discussed here:
http://office.microsoft.com/en-us/access-help/show-or-hide-object-tabs-HA001229281.aspx

Good luck

the Navigation pane code does not actually close it - it minimizes it. I want to be able to close it and open it if possible.

 

[gbnz]

I am not too sure what you mean by minimizing the Navigation Pane, but I have a database attached that illustrates my point...