Setting the Ribbon Name, and Show Navigation Pane in VBA

[Fazered]

I have been looking around on the net for a while trying to find out how to do this. I have found, so far, the following:

Application.CurrentDb.Properties("AppTitle") = "my database title here"
Application.CurrentDb.Properties("AllowFullMenus") = False
Application.CurrentDb.Properties("AllowShortcutMenus") = False
Application.CurrentDb.Properties("StartupForm") = "my opening form here"

The above all work fine, however i cannot find any way to set the 'Ribbon Name' and uncheck 'Display Navigation Pane in the current database setting of Access 2007, using VBA.

I would have thought that it would be similar to the method above, but i can't find a proper list of property names that can be set.

Anyone have any ideas?

 

[kenwarthen]

You have to uncheck the Display Navigation Pane in the Current Database settings for Access options, or from VBA you can select an object in the Navigation Pane and then hide the active window using the following code:

DoCmd.SelectObject acTable, "tblContacts", True
DoCmd.RunCommand acCmdWindowHide

You can set the ribbon name in the Form_Load event using

 

[kenwarthen]

Sorry, my browser crashed. You can set the ribbon name of a form using

Me.RibbonName = "rbnName"

Ken