Hide Ribbon in Access 2007

[sherwinb]

Hi,

I used the following code successfully in Access 2003 to hide the menu bar
on a form's OnLoad property:

Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i

What code should I use to hide the ribbon in Access 2007 and can I combine
the code so that the ribbon or menu bar is hidden depending on if the user
has Access 2003 or 2007?

Thanks

 

[Maurice]

You can't hide the ribbon completely. You can adjust it by making a table
filled with xml and setting this to the database.

For examples on this look at: www.accessribbon.de

When using two versions you have to take into consideration that the ribbon
and menu's are totally different from each other. If you do need to make a
check you also have to provide a table with the xml inside it.

hth

 

[roger]

Oh, what fun this was:
http://msdn.microsoft.com/en-us/library/bb258192.aspx

How to: Hide the Ribbon When Access Starts
Access Developer Reference

"By default, Microsoft Office Access 2007 does not provide a method for
hiding the Ribbon. This topic describes how to load a customized ribbon that
hides all of the built-in tabs...."

 

[Maurice]

Yep, good article but you are still dumped with an empty ribbon...

 

[roger]

don't tell me.
bitch to Balmer the Apeman

Yep, good article but you are still dumped with an empty ribbon...

 

[sherwinb]

Thanks for the info

don't tell me.
bitch to Balmer the Apeman

 

[Terry]

Have a look at my post and thread (dated 02/09/08) in
microsoft.public.access.commandbarsui for a possible answer to your problem.
You may need to do version checking regarding Access 2k3 or 2k7.
Regards