Access VBA Macro Programming

(Joao Candeias) #1

The URL used in the preceding code could possibly change in the future, but this is highly
unlikely. It is a standard URL used in sample ribbons on the Microsoft web site and is built
into the Microsoft Custom UI Editor (see “Using The Custom UI Editor” later in this chapter).
You have now entered a definition for a custom ribbon. Close the table and Exit the
database completely. Reload your database so that Access will now pick up this new system
table. This is a system table and will not show in the Navigation pane unless you set it to
show system tables using Navigation Options. To do this, right-click All Access Objects at
the top of the Navigation pane and select Navigation Options from the pop-up menu. Check
the box for System Objects and click OK.
Create a new form by clicking Create in the Access menu and then click the Blank Form
icon in the Forms group of the ribbon.
Change the form view to Design View by clicking the View drop-down in the Views group
of the ribbon. Right-click the form and select Properties. On the drop-down (Selection Type)
at the top of the property windows, select Form. Scroll down to the Ribbon Name property
and enter the value “MyRibbon” (or whatever you called your ribbon) in this property. This
should be visible in the drop-down for this property.


Chapter 11: Working with the Ribbon 131


Figure 11-1 The table design window for the USysRibbons table

Free download pdf