Removing Old Context Menus in AC 2007

J

JamesJ

I have a db that was converted from AC 2003 to AC 2007. There are still old
context menus\
when I click and open the Shortcut Menu Bar property of the form.
Is there any way to delete these??

James
 
A

Albert D. Kallal

JamesJ said:
I have a db that was converted from AC 2003 to AC 2007. There are still
old context menus\
when I click and open the Shortcut Menu Bar property of the form.
Is there any way to delete these??

James

Just whack ctrl-g to jump into the code editor's debug window.....

While in the debug window, you can can then type in:

commandbars("name of menu").Delete
 
J

JamesJ

I'm assuming this must be typed and ran from the Immediate window.
I got the following error:

Runtime Error '5':
Invalid Procedure call or argument

and the Shortcut Menu Bar items remained

James
 
M

Maurice

In the forms look in designmode and look in the properties window. That's
where you will find an option shortcut menu. Remove the entries there and you
won't be bothered with them anymore.
 
A

Albert D. Kallal

JamesJ said:
I'm assuming this must be typed and ran from the Immediate window.
I got the following error:

Runtime Error '5':
Invalid Procedure call or argument

and the Shortcut Menu Bar items remained

that means you not typed in the correct name.....

Check the "combo box" list of available menus when you bring up a form in
design mode (in the "other" tab of the property sheet). That drop down list
has the name(s) of those menu bars....

I mean, you could just "leave" those menus there. They should NOT be
appearing in the application unless your forms, or the "startup" settings
have specified those custom menubars. So, simply remove the "setting" in the
"other" tab of the property sheet for those forms that have custom menu bars
set. Note that you HAVE TO do this anyway, or you start getting error
messages when forms load about not finding some macro thingly. So, just
remove the settings in the other tab. When you do this the context menus
will not appear anymore. However the above command in the debug windows has
worked for me to delete those custom menu and shortcut menu bars.

So, you **have** to go into those forms and remove the shortcut menu
settings anyway, and THEN delete the menu bar(s) using my example command in
the debug window. That delete command should work, but lets deal with that
later anway. You still have to remove the settings in each form that has a
custom shortcut menu set regardless if you can't get the delete example
command to work.....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top