HOW TO CREATE A SHORTCUT MENU FOR FORM IN ACCESS (copy,cut,paste and delete)

[ludovic_44]

Dear All,

I have some VBA code which i found on the net to create a shortcut menus on form when right-click on form
but i really dont know what is the steps to proceed to have this shortcut as right-click

Shall i paste below these code on a module or on the form load
Can you please tell me how do i proceed please, whats the step and how to put the shortcut menu on the forms properties

Please i really need how to proceed

Thanking you in advance for your kindness


Sub CreateSimpleShortcutMenu()
Dim cmbShortcutMenu As Office.CommandBar

' Create a shortcut menu named "SimpleShortcutMenu.
Set cmbShortcutMenu = CommandBars.Add("SimpleShortcutMenu", msoBarPopup, False, True)



' Add the Remove Filter/Sort command.
cmbShortcutMenu.Controls.Add Type:=msoControlButton, ID:=19

' Add the Filter By Selection command.
cmbShortcutMenu.Controls.Add Type:=msoControlButton, ID:=21

' Add the paste By Selection command.
cmbShortcutMenu.Controls.Add Type:=msoControlButton, ID:=22

' Add the delete By Selection command.
cmbShortcutMenu.Controls.Add Type:=msoControlButton, ID:=478

Set cmbShortcutMenu = Nothing

End Sub

[June7]

Looks like code came from http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

which says:
Once you've run the code, the shortcut menu is saved as part of the database. You don't have to run the same code to re-create the shortcut menu every time that you open the database.

So I suggest you put the code in a general module, then run the procedure with Run command from the VBA menu bar.

Then follow instruction:
To assign the shortcut menu to a form, form control, or report, set the Shortcut Menu property of the object to Yes and set the Shortcut Menu Bar property of the object to the name of the shortcut menu. For this example, set the Shortcut Menu Bar property to SimpleShortcutMenu.

You will find those properties on the Other tab of Property Sheet.