Converting 2003 menus to 2007/2010

  • Thread starter Thread starter Lars Brownies
  • Start date Start date
L

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
 
Getting started takes a little searching on the web for good explanations
and examples. Once you get started, the rest is pretty simple.
 
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
Click to expand...

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,

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
 
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
 
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
 
Back
Top