Looking for the Name of a Popup Shortcut Menu

[Stewart Berman]

Access 2007

If you have a form in datasheet mode and right click on a text column you
see a popup menu. I am trying to find a way to assign it to the Shortcut
Menu Bar property of a form. To do this I need to know the name of the
popup menu.

I tried walking the CommandBars collection looking of anyone that had the
same set of controls. I could not find any.

The reason for need it is that I have an applicatin where all of the menus
have been turned off. I would like to make the text column shortcut menu
available and the only way to do that is to assign it to the form.

 

[Charles Wang [MSFT]]

Hi Stewart,
No, I do not think that you can do this. Your Access had already disable
the default shortcut menu. In this case, the shortcut popup menu will not
be created when you right click a control, so you cannot capture the
shortcut menu.

You may create your custom Add-in and show it when you click your control.
This need office development knowledge which is recommended to have a new
post at microsoft.public.officedev for more dedicated assistance.

Here are some articles for your reference:
Customizing the Office Fluent User Interface in Access 2007
http://msdn.microsoft.com/en-us/library/bb187398.aspx

Customizing the 2007 Office Fluent Ribbon for Developers
http://msdn.microsoft.com/en-us/library/aa338202.aspx
http://msdn.microsoft.com/en-us/library/aa338199.aspx
http://msdn.microsoft.com/en-us/library/aa722523.aspx

http://www.databasedev.co.uk/access2007ribbon.html

Best regards,
Charles Wang

 

[Stewart Berman]

I think I was a little unclear.

I am not interested in customizing the ribbon. In fact we simply use a
USysRibbon definition to completely remove it and almost all of the commands
from the Office button.

I am simply looking to create a custom popup menu for a form in datasheet
mode and put the name of it in the form's property.

I want to look at the definition of the standard default datasheet popup
menu (that is available in a newly created database) so I can understand how
to recreate it in code. I created a simple custom popup menu editor but I
cannot find the controls that appear in the standard default datasheet popup
menu.

I extracted 199 CommandBars and their control lists from a newly created
Access 2007 database. None of them had the commands shown in the standard
datasheet popup menu. If it is not in the CommandBars collection where is
it and how can I extract its definition?

 

[Charles Wang [MSFT]]

Hi Stewart,
It should be in the CommandBars list. You can refer to this article:
Referencing command bar and control objects in Access
http://ms-access-free-zone.blogspot.com/2009/05/referencing-command-bar-and-
control.html

But was the pop-up menu generated when you retrieved the commandbars list?

Best regards,
Charles Wang

 

[Stewart Berman]

But was the pop-up menu generated when you retrieved the commandbars list?

What does that mean? Is the popup menu for a text column generated on the
fly or is it a ferment member of the CommandBars collection?

BTW, the page you referred me to below is missing all of the lists and
figures referenced in it.