Solved Query Show/Hide Totals button idMso (1 Viewer)

deletedT

Guest
Local time
Today, 19:17
Joined
Feb 2, 2019
Messages
1,218
I'd like to add the Show/Hide Column Totals In Query Result button to my customized ribbon.
But I can't find it's idMso.


2020-03-27_18-34-24.jpg



Any idea how to find it?


Thanks for any kind of advice.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 03:17
Joined
May 7, 2009
Messages
19,169
it's FaceID is 226.
 

deletedT

Guest
Local time
Today, 19:17
Joined
Feb 2, 2019
Messages
1,218
Thanks but I need to know its idMSO to be able to use it.
I have no idea how to use FaceID of a button in a ribbon's xml.


Thanks
 

Micron

AWF VIP
Local time
Today, 15:17
Joined
Oct 20, 2018
Messages
3,476
I have a couple of files for this. I will see if I can find them and whether or not they list the idmso values.
 

Micron

AWF VIP
Local time
Today, 15:17
Joined
Oct 20, 2018
Messages
3,476
This is what the spreadsheet shows but I will have to see if I can recall how to use the info. It is row 1245, which may be significant. I also have a Word doc for this but it is a PITA to work with. Still looking...
idmso1.jpg
 

Micron

AWF VIP
Local time
Today, 15:17
Joined
Oct 20, 2018
Messages
3,476
I found the Word doc. According to it, the first column in what I posted is the idMSO. The rest of the columns show the group/tab/controltype etc. info. These files are available from M$ somewhere if you need them.
 

deletedT

Guest
Local time
Today, 19:17
Joined
Feb 2, 2019
Messages
1,218
I'd be glad to have a copy. If possible. Or where I can download from Microsoft.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 12:17
Joined
Oct 29, 2018
Messages
21,358
@theDBguy thanks for the table. But unfortunately it was for Excel.
I know. Unfortunately, I haven't seen one for Access only. Cheers!

Edit: I think Micron gave you a better link...
 

theDBguy

I’m here to help
Staff member
Local time
Today, 12:17
Joined
Oct 29, 2018
Messages
21,358
No idMso there too. But I asked to have a link for download for future use.
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.

ribbon.png


totals.png
 
Last edited:

deletedT

Guest
Local time
Today, 19:17
Joined
Feb 2, 2019
Messages
1,218
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
Apparently I'm missing something here. Which one do you exactly mean?
I used idMso="GroupQueryShowHide" but I received an error.
Can you show the xml for adding that total button?

thanks.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 12:17
Joined
Oct 29, 2018
Messages
21,358
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.
 

deletedT

Guest
Local time
Today, 19:17
Joined
Feb 2, 2019
Messages
1,218
Hi. I used QueryTotalsShowHide.

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.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 12:17
Joined
Oct 29, 2018
Messages
21,358
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.
Cool. Glad to hear you got it sorted out. Good luck with your project.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 12:17
Joined
Oct 29, 2018
Messages
21,358
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...
 

Micron

AWF VIP
Local time
Today, 15:17
Joined
Oct 20, 2018
Messages
3,476
Tera, you must have missed this comment
According to it, the first column in what I posted is the idMSO
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.
 

deletedT

Guest
Local time
Today, 19:17
Joined
Feb 2, 2019
Messages
1,218
Wait a minute... If you're using idMso, why do you have onAction? Does it work? Just curious...
Sure it works. When using idMso, OnAction is ignored even if it exists in the xml.
I could have deleted that. But since it doesn't harm and I use a template, a table and VBA to build the xml, I left it be there.
 

Users who are viewing this thread

Top Bottom