Display Custom Ribbon using VBA

CP

unread,

Jan 8, 2010, 12:26:01 PM1/8/10

to

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.

李远寿

unread,

Jan 14, 2010, 7:58:10 AM1/14/10

to

"CP" <C...@discussions.microsoft.com> 写入消息
news:4F6DCF86-E917-404B...@microsoft.com...

det

unread,

Jan 13, 2010, 4:51:43 PM1/13/10

to

"CP" <C...@discussions.microsoft.com> ha scritto nel messaggio
news:4F6DCF86-E917-404B...@microsoft.com...

> __________ Informazioni da ESET NOD32 Antivirus, versione del database
> delle firme digitali 4768 (20100113) __________
>
> Il messaggio stato controllato da ESET NOD32 Antivirus.
>
> www.nod32.it
>
>
>

__________ Informazioni da ESET NOD32 Antivirus, versione del database delle firme digitali 4768 (20100113) __________

Il messaggio � stato controllato da ESET NOD32 Antivirus.

www.nod32.it

__________ Informazioni da ESET NOD32 Antivirus, versione del database delle firme digitali 4772 (20100114) __________

Il messaggio � stato controllato da ESET NOD32 Antivirus.

www.nod32.it

Kenneth French

unread,

Feb 7, 2010, 7:26:23 PM2/7/10

to

base to base i can not tell you gys.
"det" <prova@myd> wrote in message
news:u1YnFzVl...@TK2MSFTNGP06.phx.gbl...

PeteH

unread,

May 4, 2010, 2:51:29 PM5/4/10

to

"Kenneth French" <KFr...@microsoft.com> schreef in bericht
news:earobVFq...@TK2MSFTNGP05.phx.gbl...

ningning

unread,

May 4, 2010, 8:39:20 PM5/4/10

to

"Kenneth French" <KFr...@microsoft.com> д��Ϣ��:earobVFq...@TK2MSFTNGP05.phx.gbl...

>> Il messaggio ? stato controllato da ESET NOD32 Antivirus.

>>
>> www.nod32.it
>>
>>
>>
>>
>> __________ Informazioni da ESET NOD32 Antivirus, versione del database
>> delle firme digitali 4772 (20100114) __________
>>

>> Il messaggio ? stato controllato da ESET NOD32 Antivirus.
>>
>> www.nod32.it
>>
>>
>>
>

ningning

unread,

May 4, 2010, 9:29:02 PM5/4/10

to

"ningning" <dddddddd> д��Ϣ��:...

tom_willpa

unread,

May 13, 2010, 1:46:01 PM5/13/10

to

Have a nice day

PeteH

unread,

May 29, 2010, 2:33:15 PM5/29/10

to

"tom_willpa" <tomw...@discussions.microsoft.com> schreef in bericht
news:A58BE35F-E1DF-440C...@microsoft.com...
> Have a nice day

PeteH

unread,

May 29, 2010, 2:36:23 PM5/29/10

to