MS Access ribbon

Fabrice Lambert
Fabrice Lambert used Ask the Experts™
on
While writing a custom ribbon for Access, I'm having troubles removing 2 elementsin the info tab of the backstage. See attached image, I would like elements circled in red to be removed.

RibbonCreator did not help much as it hardly support the backstage view (or is that just the shareware ?), and isMso provided by Ribbon Wizard were frowned upon by Access (GroupFileProperties and GroupFileLocation).

Below, the XML I obtained:
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
    <commands>
         <command idMso="Help" enabled="false"/>
    </commands>
    <ribbon startFromScratch="true"/>
    <backstage>
         <tab idMso="TabInfo" visible="true">
              <firstColumn>
                   <group idMso="GroupDatabaseCompact"/>
                   <group idMso="GroupDatabaseEncryption" visible="false"/>
                   <group idMso="GroupFileProperties" visible="false"/>
                   <group idMso="GroupFileLocation" visible="false"/>
              </firstColumn>
         </tab>
         <tab idMso="TabOfficeStart" visible="false"/>
         <tab idMso="TabRecent" visible="false"/>
         <button idMso="FileSave" visible="false"/>
         <tab idMso="TabSave" visible="false"/>
         <tab idMso="TabPrint" visible="false"/>
         <button idMso="FileCloseDatabase" visible="false"/>
         <tab idMso="TabHelp" visible="false"/>
         <button idMso="ApplicationOptionsDialog" visible="true"/>
    </backstage>
</customUI>

Open in new window

Access-Backstage.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ste5anSenior Developer

Commented:
WIthout testing: You cannot remove everything. In such a case you need to provide a complete custom ribbon.
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

Commented:
I do not believe you can control those elements.
Most Valuable Expert 2012
Top Expert 2014

Commented:
Agree with Daniel - I don't think you can remove those.
Fabrice LambertConsulting
Distinguished Expert 2017

Author

Commented:
Well, here is what I have done so far:
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
    <commands>
         <command idMso="Help" enabled="false"/>
    </commands>
    <ribbon startFromScratch="true"/>
    <backstage>
         <tab idMso="TabInfo" visible="false"/>
         <tab idMso="TabOfficeStart" visible="false"/>
         <tab idMso="TabRecent" visible="false"/>
         <button idMso="FileSave" visible="false"/>
         <tab idMso="TabSave" visible="false"/>
         <tab idMso="TabPrint" visible="false"/>
         <button idMso="FileCloseDatabase" visible="false"/>
         <tab idMso="TabHelp" visible="false"/>
         <button idMso="ApplicationOptionsDialog" visible="true"/>
         <tab id="IdTabInfo" label="Informations">
              <firstColumn>
                   <group id="IdApplicationGroup" label="Application name">
                        <topItems>
                             <labelControl id="IdDatabaseFilePath" label="c:\.......\database.accdb"/>
                        </topItems>
                   </group>
                   <group id="IdFileCompactAndRepairDatabaseGroup" label="Compacter et Réparer">
                        <primaryItem>
                             <button id="IdFileCompactAndRepairDatabase" imageMso="FileCompactAndRepairDatabase" label="Compacter et réparer la base de données"/>
                        </primaryItem>
                        <topItems>
                             <labelControl id="IdFileCompactAndRepairDatabaseDescription" label="Limitez et corrigez tout problème éventuel lié au fichier de base de données à l'aide de l'option Compacter et réparer"/>
                        </topItems>
                   </group>
                   <group id="IdDatabaseLinkTablesGroup" label="Lier aux données">
                        <primaryItem>
                             <button id="IdDatabaseLinkTables" imageMso="DatabaseLinedTableManager" label="Lier une base de données" isDefinitive="true"/>
                        </primaryItem>
                        <topItems>
                             <labelControl id="IdDatabaseLinkTablesDescription" label="Liez l'application à vos données de travail à l'aide de l'option Lier aux données"/>
                        </topItems>
                   </group>
              </firstColumn>
              <secondColumn>
                   <group id="IdAboutGroup" label="A propos">
                        <topItems>
                             <labelControl id="IdVersion" label="Version 1.0.0"/>
                             <labelControl id="IdDateVersion" label="Du 10/11/2018"/>
                        </topItems>
                   </group>
              </secondColumn>
         </tab>
         <button id="IdFileExit" imageMso="FileExit" label="Quitter"/>
    </backstage>
</customUI>

Open in new window

But, for some reasons, the New and Share tabs remain visible with Access 365, and if I try to hide them, Access raise an error.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial