Hiding the ribbon and quick access tool bar from user in access 2007 1

[chiefvj]

Why can't Microsoft upgrade Access without completely changing the look. In Access 2003 I can easily disable the shift key and hid the tool bar.. etc . How can i do that in Access 2007?

 

[FancyPrairie]

To create a custom ribbon and/or hide the default one, create a table named USysRibbons with 3 columns:
ID .... AutoNumber
RibbonName ... Text (255 field size)
RibbonXml .... Text (memo)


Open the table and enter a RibbonName (whatever name you want to give it). Then enter the following code in RibbonXml.

<customUI xmlns="

http://schemas.microsoft.com/office/2006/01/customui"

<ribbon startFromScratch="true">
</ribbon>
</customUI>

You must exit your Access application and then launch it again for your changes to the ribbon to take effect.

Now open your form in design view and set the Ribbon Name property to the RibbonName you specified in the table. Now when you open the form, no ribbon will be shown.

 

[chiefvj]

Thank you very much for your prompt response. I will give it a try.

 

[MrKABC]

One slight change:

The line of code

<customUI xmlns="

http://schemas.microsoft.com/office/2006/01/customui">

Was missing an end caret. FTFY. Your code worked beautifully!! A star for you! =)

A.