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 Edit Field Rules in Access 2007

A: Open the Microsoft Access database. Click "Start" on the main menu and choose "All programs". From the program menu, choose "Microsoft Offic...(more)

Q:How to Use the Access 2007 Query Wizard

A: Start Access 2007 and open an Access 2007 database or project. The Database window appears automatically and displays shortcuts for opening ...(more)

Q:How to Get Rid of the "Enter Parameter Value" Box in an Access 2007 Query

A: Note the name of the identifier when the "Enter Parameter Value" dialog box appears in the Microsoft Access 2007 application. Click on the...(more)

Q:Tutorial for Access 2007 Query Tables

A: Open your Microsoft Access 2007 database. Select the "Create" tab. Select "Query Design" from the "Other" group. Select the table you ...(more)

Q:How to Use the Yes/No Field in Access 2007

A: Open the Microsoft Access 2007 program on your computer, and select the "Microsoft Office" button. Click on the "Open" option. Select the ...(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