473,320 Members | 2,117 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How do I Set a Descripition to a Button on my Ribbon

I have new ribbon, that has a few buttons.
How am I add descripition to the new buttons I add?
Mar 7 '12 #1
6 1811
NeoPa
32,556 Expert Mod 16PB
I don't have ribbons as I still use 2003, but whoever considers answering this question will need to know if you are creating the ribbon via the interface or code.
Mar 8 '12 #2
I do not believe there is an interface for creating a ribbon in Access 2007. I use the system table ‘USysRibbons’ method of loading ribbons, described in this link http://www.accessribbon.de/en/?Access_-_Ribbons
I am guessing by description you mean label. the XML code for creating a button with a label is
Expand|Select|Wrap|Line Numbers
  1. <button id="MybuttonID" label="My Label" screentip="My Screen Tip" onAction="MyOnActionButton"/>
Mar 8 '12 #3
NeoPa
32,556 Expert Mod 16PB
As you've provided the XML code, maybe you'd like to explain how it's used. It's not typical (in my experience) to use XML when developing in VBA.
Mar 8 '12 #4
Stewart Ross
2,545 Expert Mod 2GB
@NeoPa, customising the ribbon is done in XML, and is far from a simple task - and nor is it something straightforward to explain.

This MSDN article is an introduction to Customising the Fluent Ribbon.

-Stewart
Mar 8 '12 #5
ADezii
8,834 Expert 8TB
  1. The USysRibbons Table must be created and consist of at least the following 3 Fields:
    1. [ID] - AutoNumber - LONG
    2. RibbonName - TEXT {255}
    3. RibbonXML - MEMO
  2. The XML Code is dumped initp the RibbonXML Field like so:
    Expand|Select|Wrap|Line Numbers
    1. <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
    2.   <ribbon startFromScratch="false">
    3.     <tabs>
    4.       <tab idMso="TabCreate" visible="false" />
    5.       <tab id="dbCustomTab" label="A Custom Tab" visible="true">
    6.         <group id="dbCustomGroup" label="A Custom Group">
    7.           <control idMso="Paste" label="Built-in Paste" enabled="true"/>
    8.         </group>
    9.       </tab>
    10.     </tabs>
    11.   </ribbon>
    12. </customUI>
  3. The XML Code first instructs Access not to 'start from scratch' — that is, it specifies that Access should display the default Ribbon Tabs. Then, it tells Access to hide just one of the default Tabs (the Create tab). Finally, it creates a new Ribbon Tab named 'A Custom Tab', adds a Command Group named 'A Custom Group' to the Tab, and adds the Paste command to the Group.
  4. Close the USysRibbons Table, and then close and reopen the Database.
Mar 8 '12 #6
NeoPa
32,556 Expert Mod 16PB
Thanks guys. That's very illuminating.

I won't divert the thread off track, but I will comment that I look forward to looking into this more when I upgrade. Looks like fun, and your example, ADezii, brought the idea home in a way that articles can't easily.
Mar 8 '12 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: ARC | last post by:
Hello, I'm struggling with trying to get a ribbon toggle button to have one image displayed if pushed in, and a different image if not pressed in. Here's the entry for the button in the USysRibbons...
0
by: ARC | last post by:
Hello all, I'm a bit stumped on this one. I have a ribbon menu where I am allowing the users to hide main options that they don't use. I use a separator id in between each option to get a...
0
by: ARC | last post by:
Well, maybe not interesting, more like hair-pulling. Ok, so if you want to code misc. utilities and forms for the office button (Like a registration screen, backup, setup options, connect to...
2
by: D Hammer - Sayner | last post by:
I am new to using Access 2007 and a novice with Access period. I have two older databases that I created in Access 2000. When I open DB1 I get the usual ribbon menus shown. When I open DB2...
4
by: scubasteve | last post by:
Hi, I'm having issues with AC2007 custom ribbons. I'm building an AC2007 runtime app which has a custom ribbon (called CommandsDisabledHideRibbon) set as the default db ribbon name (see XML at...
8
by: evenlater | last post by:
I have an .accde file with custom ribbons and with "Allow Full Menus" set to False, but the Office Button menu still gives the user the ability to create a new Access database, or -- much worse --...
3
by: jubergolandaj | last post by:
I am working on Outlook Addin developed in C# and VS-2008. In this we are having our own custom form .oft On this form we have our custom “Send” button on click event of it our processing continues....
0
by: liadmz | last post by:
I'm trying to build an Outlook add-on. I have build a nice set of buttons inside a new tab in the ribbon, but I don't know how to refer \ access the current message (which the ribbon is at). My...
0
by: Lyu KingT | last post by:
hi, i need to control the right of a Office document in my Visual Studio Projects, so how to enable or disable the print, what abou edit, save..... i try to fellow the video How Do I: Hi-jack...
0
by: bullfrog83 | last post by:
I'm creating my own ribbon for my Access db using xml (I am a novice at this, however.). Is there a way to have a form open when a user clicks on a ribbon tab? I know you can open a form by using a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.