I know. Unfortunately, I haven't seen one for Access only. Cheers!@theDBguy thanks for the table. But unfortunately it was for Excel.
Edit: I think Micron gave you a better link...
What? I thought he just showed it above. I gave it a try, and here's what I got. The first one is my usual demo ribbon. The second one is after I added it.No idMso there too. But I asked to have a link for download for future use.
Apparently I'm missing something here. Which one do you exactly mean?What? I thought he just showed it above. I gave it a try, and here's what I got. The first one is my usual demo ribbon. The second one is after I added it.
View attachment 80244
View attachment 80247
Hi. I used QueryTotalsShowHide.Apparently I'm missing something here. Which one do you mean?
I used idMso="GroupQueryShowHide" but I received an error.
Can you show the xml for adding that total button?
thanks.
Hi. I used QueryTotalsShowHide.
<toggleButton idMso="QueryTotalsShowHide" size="large" getLabel="GetLabel"
tag="RibbonName:=;inMenu:=;CustomTagValue1:=;CustomTagValue2:=;CustomTagValue3:=;CustomPicture:=;CustomPicturePath:="
onAction="OnActionButton" getVisible="GetVisible" getEnabled="GetEnabled" />
Cool. Glad to hear you got it sorted out. Good luck with your project.I was using Button for my xml. Hence the error.
I changed it to ToggleButton and now it's OK.
I hadn't noticed Total is not a button. but a ToggleButton.
Now it's my xml and it shows the button.
XML:<toggleButton idMso="QueryTotalsShowHide" size="large" getLabel="GetLabel" tag="RibbonName:=;inMenu:=;CustomTagValue1:=;CustomTagValue2:=;CustomTagValue3:=;CustomPicture:=;CustomPicturePath:=" onAction="OnActionButton" getVisible="GetVisible" getEnabled="GetEnabled" />
@theDBguy @Micron
Million thanks.
Wait a minute... If you're using idMso, why do you have onAction? Does it work? Just curious...I was using Button for my xml. Hence the error.
I changed it to ToggleButton and now it's OK.
I hadn't noticed Total is not a button. but a ToggleButton.
Now it's my xml and it shows the button.
XML:<toggleButton idMso="QueryTotalsShowHide" size="large" getLabel="GetLabel" tag="RibbonName:=;inMenu:=;CustomTagValue1:=;CustomTagValue2:=;CustomTagValue3:=;CustomPicture:=;CustomPicturePath:=" onAction="OnActionButton" getVisible="GetVisible" getEnabled="GetEnabled" />
@theDBguy @Micron
Million thanks.
What you used is the Group Name property, but you say by switching to toggle button it works? I'm no expert in ribbon xml, so I don't understand how it works. I guess I had the wrong info re which column is the idMSO.According to it, the first column in what I posted is the idMSO
Sure it works. When using idMso, OnAction is ignored even if it exists in the xml.Wait a minute... If you're using idMso, why do you have onAction? Does it work? Just curious...