Converting 2003 menus to 2007/2010

[Lars Brownies]

In A2003 I've created lots of custom menus linked to VBA functions. When
converting such apps to A2007/A2010 how easy/hard will it be to convert
those menus to the ribbon functionality without using third party add-ons?

Thanks,

Lars

 

[Paul Shapiro]

Getting started takes a little searching on the web for good explanations
and examples. Once you get started, the rest is pretty simple.

 

[John W. Vinson]

In A2003 I've created lots of custom menus linked to VBA functions. When
converting such apps to A2007/A2010 how easy/hard will it be to convert
those menus to the ribbon functionality without using third party add-ons?

Thanks,

Lars

The menus have largely been replaced by the ribbon. This change is one of the
most disruptive features of the 2007 release if you're a heavy custom menu
user!

See

http://allenbrowne.com/Access2007.html

for some of the major changes in this release.

 

[Lars Brownies]

Thanks John, Paul.
Now I know what I have to do in June...

Lars

 

[roccogrand]

Lars,

Please tell me what code you have behind your A2003 menus or give me a
reference to a book about this method. I have seen one app that is enabled
this way but I didn't look at the code.

In Access 2007, I have grabbed images from the Net and added code to them to
open forms. This is not what you want to do but it works for me.

Thanks.

David

 

[Lars Brownies]

David,

While in 'menu editing' mode you right click on the menu item and you choose
properties. There you have a field called something like 'On action'. There
you can enter for instance:
=fFormAction(3)
which refers to a vba procedure I made. As you can see you can even pass a
parameter with it. Apparently this works differently in A2007.

Lars

 

[roccogrand]

Thanks Lars,

I have only seen custom menus in an app once.

My understanding is that the Ribbon in A2007 can be controlled by XML code.
And I have never done that myself. But I have added images to a form and
linked them to OpenForm and OpenReport events. I just can't imagine needing
anything more than a few buttons to control actions--considering that
application architects recommend less than 10.

I do have one form that uses code developed by OpenGate Software that
"expands and contracts" a subform, like a dropdown menu but the subform
window opens to the right. Check their website if you are interested.

David