Activedatasheet shortcut menu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all.
I am working with the screen.activedatasheet. I can set my own shortcut
menu that is activeated when the user right clicks in the data portion of the
activedatasheet

Screen.ActiveDatasheet.ShortcutMenuBar = "myPopUpMenu"

but if I move the cursor to the left side of the data sheet or into the
title bar and right click I get a standard popup menu - not the custom popup.

If I use
Screen.ActiveDatasheet.ShortcutMenu = False

then no popups appear for the activedatasheet.

I need to control what popup menu appears througout the activedatasheet
including the left side border and the titlebar at the top of the sheet.

Any help would be great,
Thanks in advance
Gordon
 
I saw that no one responded to your posting and just registered to be able to provide some info...

The easiest way is to modify the builtin Shortcut Menus rather than applying your own custom shortcut menu. If it doesn't need to change from one datasheet to the next, you can simply modify them through the Customize Menu interface that Access provides. Otherwise you can access them through the public MenuBars collection.

The following are applicable for a form.

Form Datasheet
Form Datasheet Column
Form Datasheet Subcolumn
Form Datasheet Row
Form Datasheet Cell

I believe there are different ones for tables and queries and anything else that can have a datasheet view.

Which one pops up depends on whether a row, a column or just a cell is hilighted.

I'm planning on creating a dynamic menu system that provides different actions depending on what columns are present and/or selected. It's the only way to be able to provide common actions on forms and queries that my users create.

I hope this helps.
 
Back
Top