 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / May 2008Custom command and Menu bars in Access 2007
Custom Menu & Command bar created in earlier versions of access will only appear as part of the "add-in" button and not appear continously. As access 2007 is so new haven't been able to find information on how this works. Is there a way to have them present always (as in previous custom databases) or is this not possible. Not sure I like the new version. I'm losing control of parts of current databases for clients and would not recommend they upgrade. I can't prevent them accessing areas they couldn't before. I wish some of the new reference books would get here! jsrogol > I wish some of the new reference > books would get here! We're working on that.... :-) You'll need to make one tiny change to see your custom menu bars/toolbars *as* menu bars/toolbars 1. Click the Microsoft Office Button in the upper left corner. 2. Click the Access Options button in the bottom right corner 3. Click the Current Database category on the Access Options dialog box 4. In the Ribbon and Toolbar Options section select your menu bar name from the Menu Bar combo box 5. Click Ok to save and close the Access Options dialog box. 6. Close your database and then reopen. Viola! You'll see no signs of the Ribbon. Remember that you cannot make any modifications to the menu bars and toolbars through the old standard UI in 2007; the capability simply does not exist. You'll need to make these changes in an earlier version.  SignatureJeff Conrad Access Junkie - MVP http://home.bendbroadband.com/conradsystems/accessjunkie.html Access 2007 Info: http://www.AccessJunkie.com > Custom Menu & Command bar created in earlier versions of access will only > appear as part of the "add-in" button and not appear continously. As access [quoted text clipped - 6 lines] > them accessing areas they couldn't before. I wish some of the new reference > books would get here! I also have an Access application written in Access XP, which uses custom menus and toolbars (popups invoked by right-clicking). I have converted the application to Access 2007. The custom menu does not appear in the list you mention, just the toolbars. The custom menu is the main menu of the application. There is no alternative interface. The only way I can get it to appear is to set it as the menu bar of the splash screen (it does show up in that dropdown); however, it is in the ribbon under addins. I don't wan't the ribbon to show at all. I suppose I could use a custom ribbon; however, I do not see how to create one. > > I wish some of the new reference > > books would get here! [quoted text clipped - 27 lines] > > them accessing areas they couldn't before. I wish some of the new reference > > books would get here! Having done some more research, I find that there are 'ribbon designer' tools in VSTO; however, they seems backward to me. When you are designing a graphical UI, it seems that the tools should allow you to lay out your ribbons the way you want them to look and write the xml behind, similar to the way FrontPage works with html. With all the limitations in the object model for commandbars, at least you had a graphical design interface to start with. I have no wish to write XML and paste the successive approximations into an Access table, then open the application each time to see if the ribbon is the way i wanted it. This would take forever. How about a 'split view' designer so you can see what you are doing as you go? 'Designing' a ribbon by writing XML is a step back into the dark ages, like authoring web sites with Notepad. > I also have an Access application written in Access XP, which uses custom > menus and toolbars (popups invoked by right-clicking). I have converted the [quoted text clipped - 39 lines] > > > them accessing areas they couldn't before. I wish some of the new reference > > > books would get here! I totally agree with you. I have spent many years developing my applications. There benefit to me is the time I save in producing complex reports. I feel that the current version of Access is a huge backward step and I can't believe that Microsoft can do no better. > Having done some more research, I find that there are 'ribbon designer' tools > in VSTO; however, they seems backward to me. When you are designing a [quoted text clipped - 53 lines] > > > > them accessing areas they couldn't before. I wish some of the new reference > > > > books would get here! Hi all, I have exactly the same problem and tryed the suggested way round. In my case when I tryed to do step 4. "In the Ribbon and Toolbar Options section select your menu bar name from the Menu Bar combo box", I dont have any entry in the combo box althought the custom toolbar apears in the add-in ribbon. Any idea why this happens? Regards, Luis soares > I totally agree with you. I have spent many years developing my applications. > There benefit to me is the time I save in producing complex reports. [quoted text clipped - 58 lines] > > > > > them accessing areas they couldn't before. I wish some of the new reference > > > > > books would get here! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.