Solve software problem quickly Share experience to help others Improve the ability of solving problem
How to Create Custom Ribbons in Access 2007?

11/16/2011 09:43 by KatyAmeglio

First answer posted by JPhillippy at 11/16/2011 09:43
Add Your Answer
10~1000 characters in length CAPTCHA:
1 Answers
  • JPhillippy
    1. Open the Microsoft Access 2007 database file on your computer that you want to create a custom ribbon in.

    2. Right-click on the top navigation bar and then click the "Navigation Options" button. Click the "Show System Objects" check box so that it's select, and then click the "OK" button.

    3. Select the "Create" tab and then click the "Table Design" option from the "Tables" group. Enter the "Field Name," "Type" and "Field Size" into the first three column headers of the table.

    4. Enter "ID," "AutoNumber" and "Long Integer" into the three columns of the second row. Enter "RibbonName," "Text" and "255" into the third row of columns. Enter "RibbonXml" and "Memo" into the last row of columns.

    5. Click the "ID" field and then select the "Design" tab. Click the "Primary Key" option and then select the "Save" option from the Quick Access toolbar. Enter "USysRibbons" into the "File Name" field, and click the "Save" button.

    6. Right-click on the "USysRibbons" table from the navigation pane and click the "Datasheet View" option from the shortcut menu. Enter "(AutoNumber)" into the "ID" field and then enter "My Tab" into the "RibbonName" field.

    7. Enter the following code into the "RibbonXml" field:

      <customUI xmlns="


      <ribbon startFromScratch="false">


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

      <tab id="dbCustomTab" label="A Custom Tab" visible="true">

      <group id="dbCustomGroup" label="A Custom Group">

      <control idMso="Paste" label="Built-in Paste" enabled="true"/>






    8. Right-click in the database table and click the "Paste" option. Close the table and reopen the database in your Access 2007 application.

    9. Click the "Microsoft Office" button and then click the "Access Options" button. Select the "Current Database" option and then click the "Ribbon Name" list.

    10. Select the customized ribbon your created and then click the "OK" button. The customized ribbon will be applied to your database.

  • Was this answer helpful? 00 · 11/16/2011 09:43
Add Your Answer
10~1000 characters in length CAPTCHA:
Related Questions
Q:How to Sort Table Data in Access 2007

A: Identify the fields you wish to sort. If you will sort on more than one field, you must determine the order of precedence for the sort. Lo...(more)

Q:How to Run a SQL Script on Microsoft Access 2007

A: Double-click your Access database file. Double-clicking the database file starts Microsoft Access and automatically loads the database. Cl...(more)

Q:How to Use Office Access 2007

A:Tables Open Access and the "Office" button. Select "New." On the right side of your computer screen, type a name for your new blank database...(more)

Q:How to Access Northwind 2007

A: Open Access 2007 and click the link labeled, "Sample" on the left side of the Access 2007 window. Click the "Northwind 2007" icon that app...(more)

Q:How to Copy a Custom Menu in Access 2007

A: Go to the Navigation Pane on the left side of the database window. If it is not open, click the double arrows at the top of the Navigation P...(more)

0 people are following

Ask a question now
Write a title for your question

Microsoft Access 2010

Track and report important information with easy-to-use database tools.
Latest version:14.0.4760.1000
OS:Windows 7/Vista/2003/XP
Total downloads:332
Rank:0 in Database Management
Download It

Share with friends

New features is coming

  • 1. Providing high-quality answers to be a verified Q&A expert
  • 2. Ask and answer questions to get Brothersoft credits

Added Successfully!


Are you sure to delete your answer?



Are you sure to choose it as the best answer?



Voted Successfully!


You can't vote for yourself


You can't choose your own answer