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.
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.