How to: Create a Shortcut Menu for a Form, Form Control, or Report

re: How to: Create a Shortcut Menu for a Form, Form Control, or Report

TennChris — Thu, 27 Jan 2011 04:44:31 GMT

Ans. In code, the easiest is to just delete the custom command bar. If the command bar name is SimpleShortCutMenu, then use:

CommandBars.Item("SimpleShortcutMenu").Delete

One can also delete individual control items in the command bar, but why bother when it is easier to delete and recreate. To delete individual control items use something like:

CommandBars.Item("SimpleShortcutMenu").Controls.Item(3).Delete

where 3 is the third control command in the shortcut menu.

CommandBars.Item("SimpleShortcutMenu").Controls.Item("Find").Delete

where "Find" is the name of the control command

re: How to: Create a Shortcut Menu for a Form, Form Control, or Report

TennChris — Wed, 26 Jan 2011 18:19:06 GMT

How does one delete a custom shortcut menu created with this code? It must be so easy I'm missing it. Thanks. BTW, nice coding.

re: How to: Create a Shortcut Menu for a Form, Form Control, or Report

Tony D'Ambra — Fri, 22 May 2009 02:23:19 GMT

A very useful article. Forced by the poor documentation on this functionality in the Access 2007 Help file and from MDSN, I have been using a workaround, that in a way is both easier and more flexible, and embeds the custom popups in the actual database. You need Access 2003 installed on the development machine. As any serious Access developer retains at least the previous version of Access on his machine, this should not be an issue. In an Access 2003 MDB create your library of custom popup commandbars the easy way using the Customize dialog. In your Access 2007 MDB or ACCDB, from the RibbonBar, use the Get External Data commands to invoke the Import Objects dialog (to import from the Access 2003 database), click Options>>, check "Menus and Toolbars", and click OK. All you're custom popups are now available for assignment using the form properties dialog or VBA.