asked on

Custom Shortcut Menus in MS Access 2007

I have customized my MS Office Ribbon by adding the "USysRibbons" table (with XML-formatted data). Is there a similar way to customize the Shortcut Menu Bar? (It would seem possible, considering that when you go to: "Access Options", under "Ribbon and Toolbar Options", the "Ribbon Name" and "Shortcut Menu Bar" look almost identical -- so shouldn't their customization process be similar?) I am specifically looking for a way to customize it without using macros.

Thanks!

ASKER CERTIFIED SOLUTION

Dale Fye

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

chrisragazzi

ASKER

I *am* okay with VBA.

I guess the thing that kind of throws me off is that on the Form Load event you have to instantiate the menus... (as opposed to the menu just being there -- as it is with the custom Ribbons)... otherwise, if a Form references an un-instantiated shortcut menu, I get the following error:

Microsoft Office can't find the object 'MyFormMenu.'
If 'MyFormMenu' is a new macro or macro group, make sure you have saved it and that you have typed its name correctly.

Perhaps I'm just being nit-picky.

Dale Fye

Totally understand. I've been using this method since Access 2002. I just find it easier to copy the menus than to use the External Data, Import, then Options and check the menu option. I always thought that was a pain in the butt (sort of like creating xml for the ribbons).

I generally instantiate all of the menus in the Load event of my splash form. Once they are instantiated, you don't have to do so again.

chrisragazzi

ASKER

The solution wasn't quite what I was looking for, but the answerer did give me a thoroughly thought-out workaround.