Ribbon idMso for TabHome?

  • Thread starter Thread starter James
  • Start date Start date
J

James

Software: Access 2007 with 2002/2003 file format.

Goal: Hide portions of Ribbon under Home tab including: some View buttons,
GroupTextFormatting, and GroupRichText.

Problem:
1) Incorrectly guessing idMso for Home tab based upon Error message
indicating “Failed to find Office control by ID. ID: TabHomeâ€. The
recommended method in Office Help to identify idMso is via Access
Options/Customize but this does not provide idMso for Tabs. The other tab
idMso names I guessed at and they work...just not TabHome or any other
variants.

Example of Code resulting in Error (TabHome call towards bottom):
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="false">
<tabs>
<tab idMso="TabAddIns" visible="false" />
<tab idMso="TabCreate" visible="false" />
<tab idMso="TabDatabaseTools" visible="false" />
<tab idMso="TabExternalData" >
<group idMso="GroupSharepointLists" visible="false" />
<group idMso="GroupCollectData" visible="false" >
</group>
</tab>
<tab idMso="TabHome" >
<group idMso="GroupViews" >
<control idMso="ViewsDesignView" visible="false" />
</group>
<group idMso="GroupTextFormatting" visible="false" />
<group idMso="GroupRichText" visible="false" >
</group>
</tab>
</tabs>
</ribbon>
</customUI>
 
Hi James,

You have th idMso correct, it's TabHome so something else is bugging you. I
read your post but i can't seem to find anything that's bugging you. What i
can suggest is doing the following:

Create a seperate xml file from scratch which just disbales one group from
the HomeTab and see if that part works. Drill your way down by adding
different options you want to hide and you should catch the one that's
bugging you.

I'd start first by setting the TabHome to not visible for starters so you
know that this isn't the problem.
 
I know this is an old thread but I couldn't stand to leave incorrect information here. TabHome is not correct. In MS Access it's TabHomeAccess.

In Access the Core Tabs are as follows:
TabPrintPreviewAccess
TabHomeAccess
TabCreate
TabExternalData
TabDatabaseTools
TabSourceControl
TabAddIns

Any other tabs that want to popup are actually context tabs and are contained within "tab sets".
You can disable a tab set like this:
<contextualTabs>
<tabSet idMso="TabSetTableToolsDatasheet" visible="false" />
</contextualTabs>

Here's a list of Tab Sets:
TabSetFormToolsLayout
TabSetFormToolsLayout
TabSetFormTools
TabSetFormTools
TabSetReportToolsLayout
TabSetReportToolsLayout
TabSetReportToolsLayout
TabSetReportTools
TabSetReportTools
TabSetReportTools
TabSetRelationshipTools
TabSetQueryTools
TabSetMacroTools
TabSetPivotTableAccess
TabSetPivotChartAccess
TabSetTableToolsDatasheet
TabSetTableToolsDesign
TabSetAdpFunctionAndViewTools
TabSetAdpStoredProcedure
TabSetAdpSqlStatement
TabSetAdpDiagram

Within tabs are control groups. Here's a list of all the control groups in all the various tabs:
GroupPrintPreviewPrintAccess
GroupPageLayoutAccess
GroupZoom
GroupPrintPreviewData
GroupPrintPreviewClosePreview
GroupViews
GroupClipboard
GroupTextFormatting
GroupRichText
GroupRecords
GroupSortAndFilter
GroupWindowAccess
GroupFindAccess
GroupCreateTables
GroupCreateForms
GroupCreateReports
GroupCreateOther
GroupImport
GroupExport
GroupCollectData
GroupSharepointLists
GroupMacro
GroupViewsShowHide
GroupAnalyze
GroupMoveData
GroupDatabaseTools
GroupAdminister
GroupDatabaseSourceControl
GroupSourceControlShow
GroupSourceControlManage
GroupAddInsMenuCommands
GroupAddInsToolbarCommands
GroupAddInsCustomToolbars
GroupViews
GroupFontAccess
GroupFormatting
GroupFormattingGridlines
GroupFormattingControls
GroupAutoFormatAccess
GroupMarginsAndPaddingControlLayout
GroupControlAlignmentLayout
GroupControlPositionLayout
GroupFieldsTools
GroupViews
GroupFontAccess
GroupDesignGridlines
GroupControlsAccess
GroupToolsAccess
GroupAutoFormatAccess
GroupMarginsAndPadding
GroupControlAlignment
GroupSizeAndPosition
GroupPosition
GroupLayoutShowHide
GroupViews
GroupFontAccess
GroupFormatting
GroupGroupingAndTotals
GroupFormattingGridlines
GroupFormattingControls
GroupAutoFormatAccess
GroupMarginsAndPaddingControlLayout
GroupControlAlignmentLayout
GroupPositionLayout
GroupFieldsTools
GroupPageLayoutAccess
GroupViews
GroupFontAccess
GroupGroupingAndTotals
GroupDesignGridlines
GroupControlsAccess
GroupToolsAccess
GroupAutoFormatAccess
GroupMarginsAndPadding
GroupControlAlignment
GroupPosition
GroupControlSize
GroupLayoutShowHide
GroupPageLayoutAccess
GroupRelationshipsTools
GroupRelationships
GroupQueryResults
GroupQueryType
GroupQuerySetup
GroupQueryShowHide
GroupQueryClose
GroupMacroTools
GroupMacroRows
GroupMacroShowHide
GroupMacroClose
GroupViews
GroupPivotTableShowHideAccess
GroupPivotTableSelections
GroupPivotTableFilterAndSort
GroupPivotTableDataAccess
GroupPivotTableActiveFieldAccess
GroupPivotTableToolsAccess
GroupViews
GroupPivotChartShowHide
GroupPivotChartFilterAndSort
GroupPivotChartDataAccess
GroupPivotChartActiveFieldAccess
GroupPivotChartType
GroupPivotChartTools
GroupViews
GroupFieldsAndColumns
GroupDataTypeAndFormatting
GroupDatasheetRelationships
GroupSharePointList
GroupViews
GroupTableDesignTools
GroupTableDesignShowHide
GroupSharePointList
GroupViews
GroupAdpQueryTools
GroupAdpOutputOperations
GroupViews
GroupAdpQueryTools
GroupAdpOutputOperations
GroupAdpQueryType
GroupViews
GroupAdpSqlStatementDesignTools
GroupViews
GroupSchemaTools
GroupAdpDiagramShowHide
GroupAdpDiagramLayout
 
Back
Top