Converting 2003 menus to 2007/2010
in [General]
|
From: Lars Brownies on 29 Apr 2010 11:20 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" <roccogrand(a)discussions.microsoft.com> schreef in bericht news:A596F438-5079-4C73-837D-C357D7259984(a)microsoft.com... > 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" wrote: > >> Thanks John, Paul. >> Now I know what I have to do in June... >> >> Lars >> >> "John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> schreef in bericht >> news:9139t5hv4ep22eft9jdb09pt4mdogp22p8(a)4ax.com... >> > On Sun, 25 Apr 2010 07:39:06 +0200, "Lars Brownies" <Lars(a)Browniew.com> >> > wrote: >> > >> >>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. >> > -- >> > >> > John W. Vinson [MVP] >> >> . >>
From: roccogrand on 29 Apr 2010 22:32
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 "Lars Brownies" wrote: > 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" <roccogrand(a)discussions.microsoft.com> schreef in bericht > news:A596F438-5079-4C73-837D-C357D7259984(a)microsoft.com... > > 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" wrote: > > > >> Thanks John, Paul. > >> Now I know what I have to do in June... > >> > >> Lars > >> > >> "John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> schreef in bericht > >> news:9139t5hv4ep22eft9jdb09pt4mdogp22p8(a)4ax.com... > >> > On Sun, 25 Apr 2010 07:39:06 +0200, "Lars Brownies" <Lars(a)Browniew.com> > >> > wrote: > >> > > >> >>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. > >> > -- > >> > > >> > John W. Vinson [MVP] > >> > >> . > >> > . > |