Access.2007.VBA.Bibl..

To remove a built-in tab or group from the Ribbon, you need to know its name. The

AccessRibbonControls.xls worksheet is useful for finding the names of tabs or groups: just sort the

worksheet by Control Type, and look at the tab or group rows. To save time, the names of the stan-

dard tabs are listed in Table 15.4.

TABLE 15.4

Built-in Access Ribbon Tab Names

TabAddIns TabPivotChartDesign

TabAdpDiagramDesign TabPivotTableDesign

TabAdpFunctionAndViewToolsDesign TabPrintPreviewAccess

TabAdpSqlStatementDesign TabQueryToolsDesign

TabAdpStoredProcedureToolsDesign TabRelationshipToolsDesign

TabControlLayout TabReportToolsAlignment

TabCreate TabReportToolsDesign

TabDatabaseTools TabReportToolsFormatting

TabExternalData TabReportToolsLayout

TabFormToolsDesign TabReportToolsPageSetupDesign

TabFormToolsFormatting TabReportToolsPageSetupLayout

TabFormToolsLayout TabSourceControl

TabHomeAccess TabTableToolsDatasheet

TabMacroToolsDesign TabTableToolsDesignAccess

Table 15.5 lists the standard group names.

TABLE 15.5

Built-in Access Ribbon Group Names

FileManageMenu GroupAdpOutputOperations

FilePrintMenu GroupAdpQueryTools

FileSaveAsMenuAccess GroupAdpQueryType

FileServerMenu GroupAdpSqlStatementDesignTools

GroupAdminister GroupAnalyze

GroupAdpDiagramLayout GroupAutoFormatAccess

GroupAdpDiagramShowHide GroupClipboard

continued

Customizing the Ribbon with XML in Access Databases and Add-ins 15