Custom Shortcut Menu Not Working For Datasheet Columns

[Stewart Berman]

Access 2007

I have a custom shortcut menu that I assigned to the Shortcut Menu Bar of
the form object. When the form is displayed in datasheet mode the custom
shortcut menu is shown when the user right clicks on a cell. It is not
shown when the user right clicks on the heading of a column or selects an
entire column and then right clicks anywhere in the column. Instead the
standard shortcut menu is shown.

How do I override the shortcut menu that is shown when you right click on a
column heading in datasheet mode?

 

[Charles Wang [MSFT]]

Hi Stewart,
Happy New Year! Sorry for delaying this response due to New Year Vacation.

From your description, I understand that you would like to also show your
custom shortcut menu when you right click on a column heading in the
datasheet mode.
If I have misunderstood, please let me know.

To let me better understand the problem you are facing and perform
effective research, could you please first send me a copy of your access
file for quickly reproducing this issue? You can send the file to me at
changliw_at_microsoft_dot_com.

Thanks.

Best regards,
Charles Wang

 

[Stewart Berman]

I sent you an email with a sample database attached. To make the
information available to the newsgroup this is the message I sent:

I did not fully describe the problem. It occurs if the form is in a subform
control.

The attached database has two forms. Both forms have their Shortcut Menu
property set to CustomMenuTest (which is a two control popup menu).

Form2 contains Form1 in a subform control.

If Form2 is open and you select a cell in Form1 and right click you will see
the custom menu. If you select a column by left clicking on its heading and
then right click you will see the regular menu not the custom menu.

However, if you open Form1 itself and do the same thing you will only see
the custom shortcut menu whether you select a single cell or a column.

 

[Stewart Berman]

Did you get the database I sent you?

 

[Charles Wang [MSFT]]

Hi Stewart,
I checked my mail box but did not find your mail with the database. What is
the size of the database? If it is over 2MB, could you please first send me
an email and I will create a workspace for your uploading the file?

If it is less than 2MB, could you please send it to me again? Thank you!

Best regards,
Charles Wang

 

[Stewart Berman]

It was a 16KB zip archive.

I'll send it again.

 

[Charles Wang [MSFT]]

Hi Stewart,
Thank you for uploading the file to me.

I have easily reproduce your issue. Based on my research, this is probably
a product issue. Currently we are internally discussing this issue. I will
give you the next update in the following one or two days.

Best regards,
Charles Wang

 

[Charles Wang [MSFT]]

Hi Stewart,
I have just got the confirmation from product group. The issue you
encountered is indeed a legacy product issue since Access 2003.
Unfortunately there is no fix for this issue so far. If you really have
concerns on this, as a workaround, please consider not to use a subform,
instead pop up a new form.

Please do not hesitate to let me know if you have any other questions or
concerns.

Best regards,
Charles Wang

 

[Stewart Berman]

Is this the reason I can't find the commandbar object for the default
behavior that occurs when you right click on a column heading? Is the popup
menu being built in the click event?

I have a form with five sub form controls
<--------------------- Sub Form Top ----------------------------->
<------ Sub Form Left Middle --><--------Sub Form Right Middle -->
<------ Sub Form Left Bottom --><--------Sub Form Right Bottom -->

The controls are pointed to different forms depending on how the user is
viewing the data. So using a new form or a popup is not a solution.

Will this be fixed in 2007 or in 2010? Where can I find a list of the known
legacy product issues so I don't waste time trying to fix my code when it is
a known problem?

 

[Charles Wang [MSFT]]

Hi Stewart,
Thank you for your response.

Since this issue is a product issue, to track down the root cause and
answer your further questions of the problem you encountered, I recommend
that you directly contact Microsoft Customer Support Services (CSS) via
telephone so that a dedicated Support Professional can assist you in a more
efficient manner. Please be advised that contacting phone support will be a
charged call but your charged fee will be refunded if it is a product issue.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

Best regards,
Charles Wang

 

[Stewart Berman]

I think I'll pass on giving a credit card number to Microsoft to find out if
a bug known about for two versions will be fixed.