Avatar of billpars
billpars
Flag for United States of America

asked on 

How do I customize the Save As tab in the MS Access Backstage?

I need to address two related issues in the following Custom UI for Access 2016:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
    <ribbon startFromScratch="true"/>
    <backstage>

        <!-- Hide Home tab. -->
        <tab idMso="PlaceTabHome" visible="false"/>

        <!-- Hide New tab. -->
        <tab idMso="TabOfficeStart" visible="false"/>

        <!-- Hide Open tab. -->
        <tab idMso="TabRecent" visible="false"/>

        <!-- Hide Info tab. -->
        <tab idMso="TabInfo" visible="false"/>

        <!-- Hide Save Database As task on Save As tab. -->
        <tab idMso="TabSave">
            <firstColumn>
                <taskFormGroup idMso="SaveGroup">
                    <category idMso="FileTypes">
                        <task idMso="SaveDatabaseAs" visible="false"/>
                    </category>
                </taskFormGroup>
            </firstColumn>
        </tab>

        <!-- Hide all but Print Preview task on Print tab. -->
        <tab idMso="TabPrint">
            <firstColumn>
                <taskGroup idMso="GroupPrint">
                    <category idMso="PrintCategory">

                        <!-- Hide Quick Print task on Print tab. -->
                        <task idMso="FilePrintQuick" visible="false"/>

                        <!-- Hide Print Dialog task on Print tab. -->
                        <task idMso="PrintDialogAccess" visible="false"/>
                    </category>
                </taskGroup>
            </firstColumn>
        </tab>

        <!-- Hide Close button. -->
        <button idMso="FileCloseDatabase" visible="false"/>

        <!-- Hide Account tab. -->
        <tab idMso="TabHelp" visible="false"/>

        <!-- Hide Feedback tab. -->
        <tab idMso="TabOfficeFeedback" visible="false"/>

        <!-- Hide Privacy Options button. -->
        <button idMso="ApplicationOptionsDialog" visible="false"/>
    </backstage>
</customUI>

Open in new window


When the database opens, the Backstage (i.e. File tab) displays this:

Screen-Shot-A.jpg(Screen Shot A)

If I open an object (say, a Query Definition), then it displays this:

Screen-Shot-B.jpg(Screen Shot B)

If I then close the database object, the Backstage does not revert to Screen Shot A, as I would expect.

Additionally, if the user clicks the "Save As" button -- with no database object open -- then the following error displays:

Error-Message.jpg

Issue #1: How do I hide the "Advanced" option ("Save As Client Object"), which is grayed-out and unavailable, but still visible, in Screen Shot B?

Issue #2: How do I get the Backstage to revert from Screen Shot B to Screen Shot A without closing/reopening the database, or otherwise avoid the above error, when no database object is open?

(I assume that my Custom UI is either incomplete or conceptually flawed.)
Microsoft OfficeDatabasesMicrosoft Access

Avatar of undefined
Last Comment
billpars

8/22/2022 - Mon