Loading a customized ribbon not associated with a form

C

CP

I have an Access 2003 application that we are converting to Access
2007. I
have (finally) figured out how to create customized ribbons to replace
the
customized menu's in the older version. And I have figured out how
to
associate specific ribbons with specific forms. Now I have to figure
out a
way to load another customized ribbon during Query Design, which
doesn't
appear to have an actual form.

The code that loads the Query Design form in the Access 2003 version
is:
DoCmd.OpenQuery strQueryFullName, acViewDesign, acEdit
DoCmd.RunCommand acCmdDesignView
DoCmd.ShowToolbar "CLS Query Design", acToolbarYes


I have read through a lot of information about using the LoadCustomUI
command to make the list of all my customized ribbons available. BUT
I can't
find anything about how to actually access the Recordset that is
created. I
think I can do Application.LoadCustomUI (customUIName, customUIXML)
for the
particular ribbon but what goes in the customUIXML parameter (I'm
guessing
that the customUIName is the name of my Ribbon or is the customUIName
= the
name of the table that contains all the ribbons and the customUIXML is
the
name of the particular ribbon)?


I'm going around and around in circles so I hope someone can help me
get out.


Thanks in advance. Carol.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top