USysRibbons - I'm confused

[ryetee]

I'm trying o hide tabs from the user and have more or less done this. When in a report however I show the print tool bar by coding the following in the on open event of the report
DoCmd.ShowToolbar "Ribbon", acToolbarYes

This works fine except I get the File tab as well which allows the user to go into options which I want to stop.

Having googled this to death I came across a forum where there was a sample database that did this.

It seems I need to set up a system table called USysRibbons. I actually copied the table from the example but I am at a loss what to do with it! I can't see anywhere in the example where it is referenced at all.

Can someone point me in the right direction.

 

[ryetee]

OK I See that in the example database I have been given he has a custom ribbon defined in USysRibbons which is referred to in the Property "Ribbon Name" for the report itslef.

There is also a record on USysRibbons with a RibbonName of rbClean2010 which looks like it is the thing I want/need to disable Options on the file tab. The RibbnXML for this is
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">

<!-- *** TAG COMMANDS ***-->
<commands>
<command idMso="Help" enabled = "false"/>
</commands>

<ribbon startFromScratch="true"/>

<!-- *** BACKSTAGE ***-->

<backstage>
<button idMso="FileSave" visible="false"/>
<button idMso="SaveObjectAs" visible="false"/>
<button idMso="FileSaveAsCurrentFileFormat" visible="false"/>
<button idMso="FileOpen" visible="false"/>
<button idMso="FileCloseDatabase" visible="false"/>
<tab idMso ="TabInfo" visible="false"/>
<tab idMso ="TabRecent" visible="false"/>
<tab idMso ="TabNew" visible="false"/>
<tab idMso ="TabPrint" visible="false"/>
<tab idMso ="TabShare" visible="false"/>
<tab idMso ="TabHelp" visible="false"/>
<button idMso="ApplicationOptionsDialog" visible="false"/>
<button idMso="FileExit" visible="false"/>
</backstage>

</customUI>

I can't however see where this is called from. Again a point in theright direction would help

 

[ryetee]

OK - found it! t's in the Ribbon and Toolbar options in the File tab Options!