I have a application in which I created the table USysRibbons and inserted a record containing the xml code for a custom ribbon. However, when I attempt to assign the ribbon to the application or a form, it does not appear in the pulldown to allow me to select it. Any thoughts would be appreciated.

Bill

Are you using the correct schema reference: http://www.microsoft.com/downloads/d...DisplayLang=en

I assume the USysRibbons table is local to the database, and not on a back end somewhere.

Here is the proper table format:
USysRibbons
   RibbonName TEXT (255) PRIMARY KEY,
   RibbonXml MEMO

Also, to see the errors, you must enable the Show Add-In User Interface Errors option in the General section of the Advanced group of the Access Options dialog box. This may show you why the ribbon is not loading.

When you get this working, you can create a file called Blank12.accdb in Office\Templates, and everytime you create a new database, Access uses that as the Blank template. Put your ribbons in that file (you will have to create the file). This works like master in SQL Server.

See: Chapter 12 - Customizing the Ribbon
Access 2007 VBA Programmer's Reference

Did any of that help?


mmcdonal

Look it up at: http://wrox.books24x7.com

Also, did you point it to your customui.xsd file?


mmcdonal

Look it up at: http://wrox.books24x7.com