Access.2007.VBA.Bibl..

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

VerticalSpacingDecrease

VerticalSpacingIncrease

VerticalSpacingMakeEqual

ViewMessageBar

ViewsAdpDiagramPrintPreview

ViewsAdpDiagramSqlView

ViewsDatasheetView

ViewsDesignView

ViewsFormView

ViewsLayoutView

ViewsModeMenu

ViewsModeMenu

ViewsPivotChartView

ViewsPivotChartView

ViewsPivotTableView

ViewsReportView

ViewsSwitchToDefaultView

ViewVisualBasicCodeAccess

VisualBasic

WindowMoreWindowsDialog

WindowNameGoesHere

WindowsArrangeIcons

WindowsCascade

WindowsDataEntry

WindowSplit

WindowsSwitch

WindowsTileHorizontally

WindowsTileVertically

WindowUnhide

Zoom100

ZoomFitToWindow

ZoomOnePage

ZoomPrintPreviewExcel

The XML code listed next (the Ribbon name is TurnOff) turns off the standard Home tab, and

removes the Export group from the External Data tab:

<customUI xmlns=

“http://schemas.microsoft.com/office/2006/01/customui”>

<ribbon startFromScratch=”false”>

<tabs>

<tab idMso=”TabHomeAccess”

visible=”false”>

</tab>

<tab idMso=”TabExternalData”

visible=”true”>

<group idMso=”GroupExport”

visible=”false”>

</group>

</tab>

</tabs>

</ribbon>

</customUI>

In order to see this (or any) custom Ribbon in an Access database, you need to select it in

NOTENOTE the “Ribbon Name” drop-down list in the Access Options dialog, as shown in Figure 15.8.