Access.2007.VBA.Bibl..

(John Hannent) #1
Removing a Tab or Group from the Ribbon ..................................................

To remove one of the standard tabs or groups from the Ribbon (in reality, you are hiding it, not
deleting it), set its visible attribute to “false”, using idMso instead of id to indicate that you are ref-
erencing a built-in Ribbon tab or group. The following line of XML code turns off the standard
Create tab:

<tab idMso=”TabCreate” visible=”false”/>

Part III Adding More Functionality to Office


Finding Control Names for Use in XML Code


I


f you want to assign a familiar Access image to a button on the Ribbon, you need to know the
name of the standard Access control that uses this image, so you can set the imageMsoargument
for the button with that name. You can download an Excel worksheet (AccessRibbonControls.xls) with
this information from http://www.microsoft.com/downloads/details.aspx?familyid=
4329d9e9-4d11-46a5-898d-23e4f331e9ae&displaylang=enon the Microsoft web site.

Even though Office 2007 has been released, the latest worksheets of control names
were prepared during the beta (November 2006), and they are not entirely accurate
for the release version of Access, especially for tab names. Hopefully an updated set of worksheets
will be posted soon.

However, there is another, more convenient method that works fine for many controls: Open the
Access Options screen from the Office menu, and click the Customization page. This page is
intended for customizing the Quick Access Toolbar, but it is also very useful for finding out control
names for use in XML code. To find a control name, first select the Ribbon tab from the “Choose
command from” drop-down list, then select the control in the list. As you hover the mouse over the
control, its name appears in parentheses after the friendly name:

Getting the control name for use in assigning an image to a control on the Ribbon.

CAUTION CAUTION

Free download pdf