UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Missing Id Codes For Msocontrol Buttons, Access 2016    
 
   
Nak
post Nov 27 2019, 08:55 AM
Post#1



Posts: 64
Joined: 10-January 11



Hi everybody
Thanks to the help of UtterAccess I was able to design a contextual menu to filter text using the id of the msoControl button. Below is an extract. Also, I downloaded the XL help file for 2016 which is supposedly containing all the ids for all mso including number filtering. Many are missing (For now, I am interested in the below 2 Ids)
* Greater Than Or equal To
* Less Than or equal To

Any idea where can I find them?
Thanks
Nak

newMenu.Controls.Add msoControlButton, 10077, , , True 'Filter equals xx
newMenu.Controls.Add msoControlButton, 10078, , , True 'Filter not equal to xx
newMenu.Controls.Add msoControlButton, 10079, , , True 'Filter beings with xx
newMenu.Controls.Add msoControlButton, 12696, , , True 'Filter does not beings with xx
newMenu.Controls.Add msoControlButton, 10080, , , True 'Filter contains xx
newMenu.Controls.Add msoControlButton, 10081, , , True 'Filter does not contains xx
newMenu.Controls.Add msoControlButton, 10082, , , True 'Filter ends with xx
newMenu.Controls.Add msoControlButton, 10083, , , True 'Filter ends with xx
newMenu.Controls.Add msoControlButton, 12697, , , True 'Filter does not ends with xx
Go to the top of the page
 
JeffK
post Yesterday, 09:22 AM
Post#2


UtterAccess VIP
Posts: 1,574
Joined: 19-December 02
From: Lansing, MI


See if 10094 and 10095 work for you.

I just got hem quickly with these in the immediate window:
?Commandbars("Table Design Datasheet Cell").Controls("&Greater Than or Equal To 211").Id
?Commandbars("Table Design Datasheet Cell").Controls("&Less Than or Equal To 211").Id

211 was the number I right-clicked on before issuing the code, so if you're trying to find more IDs yourself, you may have to modify that. I have not issued your code to add the commands to a custom bar so this is just a guess.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    6th December 2019 - 01:33 AM