PC Review


Reply
Thread Tools Rate Thread

Access 2007-Create Custom Menu

 
 
Trini Gal
Guest
Posts: n/a
 
      27th Apr 2010
Hello,

I've been searching all day and is still unable to find what I'm looking
for. I was upgraded to 2007 and have converted my Access 2003 database. I
figured out how to customize (using XML, go me) the Ribbon to only display
the tools I want the users to use, but for the life of me, I can't seem to
figure out how to add a menu to it. For example, I want to have a menu that
lists a bunch of reports.

This is the code for my Ribbon:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
<tabs>
<tab id="dbCustomTab" label="Tool Tab" visible="true">
<group id="dbCustomGroup" label="Group 1">
<control idMso="ExportExcel" label="Export To Excel"
enabled="true"/>
<control idMso="ExportTextFile" label="Export To Text"
enabled="true"/>
<control idMso="PublishToPdfOrEdoc" label="Export To PDF"
enabled="true"/>
</group>
<group id="dbCustomGroup2" label="Group 2">
<control idMso="FilePrintQuick" label="Print" enabled="true"/>
<control idMso="FilePrintPreview" label="Print Preview"
enabled="true"/>
</group>
<group id="dbCustomGroup3" label="Group 3">
<control idMso="PrintPreviewClose" label="Close" enabled="true"/>
<control idMso="FileExit" label="Exit Database" enabled="true"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>

If someone can point me in the right direction I would greatly appreciate
it. Thanks in advance for your time.
 
Reply With Quote
 
 
 
 
Trini Gal
Guest
Posts: n/a
 
      27th Apr 2010
Never mind, I figured it out, GO ME!!!

"Trini Gal" wrote:

> Hello,
>
> I've been searching all day and is still unable to find what I'm looking
> for. I was upgraded to 2007 and have converted my Access 2003 database. I
> figured out how to customize (using XML, go me) the Ribbon to only display
> the tools I want the users to use, but for the life of me, I can't seem to
> figure out how to add a menu to it. For example, I want to have a menu that
> lists a bunch of reports.
>
> This is the code for my Ribbon:
>
> <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
> <ribbon startFromScratch="true">
> <tabs>
> <tab id="dbCustomTab" label="Tool Tab" visible="true">
> <group id="dbCustomGroup" label="Group 1">
> <control idMso="ExportExcel" label="Export To Excel"
> enabled="true"/>
> <control idMso="ExportTextFile" label="Export To Text"
> enabled="true"/>
> <control idMso="PublishToPdfOrEdoc" label="Export To PDF"
> enabled="true"/>
> </group>
> <group id="dbCustomGroup2" label="Group 2">
> <control idMso="FilePrintQuick" label="Print" enabled="true"/>
> <control idMso="FilePrintPreview" label="Print Preview"
> enabled="true"/>
> </group>
> <group id="dbCustomGroup3" label="Group 3">
> <control idMso="PrintPreviewClose" label="Close" enabled="true"/>
> <control idMso="FileExit" label="Exit Database" enabled="true"/>
> </group>
> </tab>
> </tabs>
> </ribbon>
> </customUI>
>
> If someone can point me in the right direction I would greatly appreciate
> it. Thanks in advance for your time.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Menu Bar in Access 2007 Abdul Shakeel Microsoft Access 1 3rd Jun 2010 02:43 PM
How do I modify a custom menu bar in Access 2007? Jason Microsoft Access Getting Started 1 11th Aug 2009 10:02 PM
Modifying custom menu in Access 2007 PeterJC Microsoft Access VBA Modules 0 2nd Oct 2008 10:58 PM
Access 2007 Custom Menu JamesJ Microsoft Access Form Coding 0 23rd Jul 2006 08:47 PM
How Do I Create A Subcommand Option On An Access Custom Menu? =?Utf-8?B?UkRCcnVuZXQ=?= Microsoft Access Database Table Design 1 29th Jul 2005 04:35 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:49 PM.