Access 2010
I have created a custom shortcut menu for reports using VBA in the Open Event of my Startup Form. It works fine but:
1. I have to let the code run every time I open the database for it to be available to reports, otherwise I get a message that my menu cannot be found.
I understood that running the code ONCE would save my shortcut menu in the database - not in for me!
2. I would like to include the commands 'Multiple Pages' and 'Zoom' (with its dropdown list) from the default shortcut menu - can anyone tell me what 'magic numbers' I need?
I have downloaded the Help list (accesscommands.xlsx) from Microsoft but I can't find these two commands in their (very long!) list.
Any help would be gratefully received.
I have created a custom shortcut menu for reports using VBA in the Open Event of my Startup Form. It works fine but:
1. I have to let the code run every time I open the database for it to be available to reports, otherwise I get a message that my menu cannot be found.
I understood that running the code ONCE would save my shortcut menu in the database - not in for me!
2. I would like to include the commands 'Multiple Pages' and 'Zoom' (with its dropdown list) from the default shortcut menu - can anyone tell me what 'magic numbers' I need?
I have downloaded the Help list (accesscommands.xlsx) from Microsoft but I can't find these two commands in their (very long!) list.
Any help would be gratefully received.
