Jasinski Technical Wiki


Home Page
All Pages

Quick Search
Advanced Search »

Contributor Links

Create a new Page
File Management
Your Profile

Other Wiki Sections



Ribbon Creation in Access 2007

Modified on Mon, Feb 14, 2011, 12:13 PM by Administrator Categorized as Microsoft Office


This article walks through creating your own custom ribbon for Microsoft Access 2007. It is based upon this article: Customizing the Office Fluent User Interface in Access 2007.


1. Create a table in your database with two fields. Save this table as USysRibbons. You may want to make this a hidden table.

Field NameData Type

2. In the USysRibbons table, create a new record with a RibbonName of MainMenu and RibbonXML of, for example, the following.

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
  <ribbon startFromScratch="false">
      <tab id="tabMain" label="Main Menu" insertBeforeMso="TabHomeAccess">
        <group id="grpOtherClients" label="Other Clients">
          <button id="cmdProjects" label="Projects" onAction="OpenCustomJob" size="large"
            imageMso="ViewsFormView" supertip="Open the Custom Job page"/>
          <button id="cmdLongs" label="Longs" onAction="OpenAcmeJob" size="large"
            imageMso="ViewsFormView" supertip="Open the ACME Job page"/>
        <group id="grpSystem" label="System">
          <button id="cmdReports" label="Reports" onAction="OpenReportsForm" size="large"
             imageMso="ViewsReportView" supertip="Open the Reports page"/>
          <button id="cmdExit" label="Exit" onAction="ExitApplication" size="large"
             imageMso="GroupPrintPreviewClosePreview" supertip="Exit the application"/>

3. The Main Menu ribbon can now be use for the database by navigating to Office Menu button > Access Options > Current Database > Ribbon and Toolbar Options section > Ribbon Name.


ribbonstartFromScratchDetermines whether the built-in Access ribbon tabs are removed before creating this ribbon
tabinsertBeforeMsoSetting this to TabHomeAccess positions this ribbon before the built-in Home tab. Tab names can be determined from the attached spreadsheet.
buttononActionThis is the name of the macro to run when the button is clicked
buttonsizeEither large or normal
buttonimageMsoValid values can be found in the attached spreadsheet.
  • ViewsFormView = Form icon
  • ViewsReportView = Report icon
  • GroupPrintPreviewClosePreview = close button
  • QueryRunQuery = Exclamation point

  • Reference

      Name Size
    - AccessRibbonControls.zip 59.30 KB

    ScrewTurn Wiki version Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2023, Patrick Jasinski.