ADP and ribbon customisation

  • Thread starter Thread starter LenRob
  • Start date Start date
L

LenRob

I have an ADP and have tried to create a custom ribbon. The ribbon works ok
in an ACCDB but when I reate the table usysribbons (which gets created on the
SQL server) than i cannot find my custom ribbon in the Access Options/
Current Database/ Ribbon and Toolbar options. The Ribbon Name combo is empty.

Is this because the usysribbons table is on the SQL server so not supported
correctly?
 
Found the olny way seems to be by writing a bit of code to read from the
table and add the ribbon.
Code looks a bit like

Dim RS As Recordset
Set RS = CurrentProject.Connection.Execute("SELECT RibbonName,RibbonXML FROM
USysRibbons")
If Not RS.BOF Then
Application.LoadCustomUI RS("RibbonName").Value, RS("RibbonXml").Value
End If
RS.Close
Set RS = Nothing

and is run from an Autoexec macro.
 
Back
Top