troubleshooting Question

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

Avatar of billpars
billparsFlag for United States of America asked on
Microsoft OfficeDatabasesMicrosoft Access
17 Comments1 Solution113 ViewsLast Modified:
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>

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.)
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 17 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros