I have an application-specific custom ribbon interface (just adds to the standard Access ribbon) that is working perfectly in an Access 2007 db (accdb). I'm in the process of migrating this existing db to an Access Data Project (adp file) that uses SQL Server as a backend.
The problem I'm having is making the custom ribbon available in the ADP project. Apparently there is no way to define a local table in an ADP, so I can't create the USysRibbons table that contains the XML code for the ribbon - it's not recognized by Access when it's hosted on SQL Server.
So, I set up a VBA procedure that uses the LoadCustomUI method of the Access object to load the ribbon dynamically. This does get the ribbon definition into Access - the name of my custom ribbon shows up in the Ribbon Name dropdown in the Access Options dialog - but I still don't get the custom ribbon displayed.
Finally, I set up an ****** callback specified on the CustomUI node in the XML definition for the custom ribbon. When the callback runs it just executes the Invalidate method of the IRibbonUI object that's passed to the callback, which I thought would refresh the ribbon and show my custom tab - still nothing.
The way I thought this should work is that when the LoadCustomUI runs the ribbon is loaded, and the ****** callback forces a refresh of the ribbon so that it would become visible. I did enable error checking, and I don't see any errors at all when this runs, but I still get no custom ribbon displayed. As I mentioned above, this ribbon works perfectly when used with a standard accdb file so I'm at a loss as to what I'm doing wrong.
What am I missing?
The problem I'm having is making the custom ribbon available in the ADP project. Apparently there is no way to define a local table in an ADP, so I can't create the USysRibbons table that contains the XML code for the ribbon - it's not recognized by Access when it's hosted on SQL Server.
So, I set up a VBA procedure that uses the LoadCustomUI method of the Access object to load the ribbon dynamically. This does get the ribbon definition into Access - the name of my custom ribbon shows up in the Ribbon Name dropdown in the Access Options dialog - but I still don't get the custom ribbon displayed.
Finally, I set up an ****** callback specified on the CustomUI node in the XML definition for the custom ribbon. When the callback runs it just executes the Invalidate method of the IRibbonUI object that's passed to the callback, which I thought would refresh the ribbon and show my custom tab - still nothing.
The way I thought this should work is that when the LoadCustomUI runs the ribbon is loaded, and the ****** callback forces a refresh of the ribbon so that it would become visible. I did enable error checking, and I don't see any errors at all when this runs, but I still get no custom ribbon displayed. As I mentioned above, this ribbon works perfectly when used with a standard accdb file so I'm at a loss as to what I'm doing wrong.
What am I missing?