Access 2007 Ribbon- hiding groups

[dreamdelerium]

ive created a program and now need to make it 2007 friendly. i have my own custom menu bars for my forms and reports. when they load in 2007 the ribbon has my menu bars as well as all the other default ones. how do i remove, or hide, these groups from the user. i dont want them to have access to the vba code, tables, etc

 

[ron2]

this works but with one problem ~

I am also new to Access 2007 but this was 1st thing I found out about

Heres what you do:

Click the Office link icon ( extreme top left of screen = round icon)
Click Access Options (button on bottom of dialog)
Click Current database

Uncheck Navigation\Display Navigation Pane
Further down list
Select a menu bar
Select a shortcut menu

Deselect all 3 of following checkboxes
Allow full menus
Allow default shortcut menus
Allow Built in toolbars
(you probably could just uncheck the 1st one of these to remove the 'ribbon'

Click OK on bottom of pane
When pane closes you should get message to effect ".. changes will take effect"

reboot the database and all the navigation bar and the ribbon stuff will have disappeared

to get them back reboot while holding down the shift key until you can click the office link icon again.


>>>>>>>>>>>>>>>>>>

thats as far as i've got but do have one problem with this in that the first form
does not show its custom menu bar

this is not a problem if your first form is a switchboard but it is otherwise

I found that if I put a button to go to another form on the initial form and Me.Menubar = "mymenu" in the OnActivate event
When 1st form appears it has no menu, click the button to other form (this menu ok), go back to 1st form via menu
and hey the 1st forms menu comes back.

Anyone got an answer to this issue??