Can we programmatically set the default ribbon?

[amarkmac]

I'm working with a ADP in 2007 (not an accdb) in which I've defined a new custom ribbon. ADPs do not recognise the USysRibbons table, so it is not available to select through the Access Options screen. I've used the LoadCustomUI method to load the ribbon, and I can then associate it to particular forms, but I need instead to associate it to the application default.

In other words, I need to programmatically associate my ribbon to the same default parameter that the Access Options UI uses. I'm betting this is stupidly easy, like application.SetOption "Ribbon Name", "MyRibbon" or something like that, but I sure can't find it.

Hope this is an easy one. Thanks,
Mark

 

[nIGHTmAYOR]

Application.LoadCustomUI(CustomUIName As String, CustomUIXML As String)

Also

Application.LoadCustomUI "CustomUIName", CustomUIXML

<<CustomUIXML is a varrible string containing your designd FUI aka ribbon chunk>>

 

[blah]

<<CustomUIXML is a varrible string containing your designd FUI aka ribbon chunk>>

I don't think that works. Ribbons are loaded automatically -- making them "available" to choose. If the desired ribbon xml isn't in the database, that command will put it there, but it won't "launch" the Ribbon.

It appears the question is "how to choose the ribbon programmatically."

I've been searching for hours and found no answer.