Jim Dettman
jimdettman at verizon.net
Thu Nov 1 14:07:56 CDT 2007
Looks like I picked it off one of the Office Blogs. It's discussed here along with another method: http://www.utteraccess.com/forums/printthread.php?Cat=&Board=91&main=1302379 &type=thread In that thread, it says: "Couldn't get it to work. I looked at other websites - they gave nearly identical instructions. Couldn't get it to work. I gave up on the USysRibbons table idea and posted here. I followed the example by freakazeud, which worked. I was able to customize the ideas given by him, with very little problem, other than the issues we've discussed above here. I FINALLY figured out that it looks like the XML code in step 3 (Iin the quote above) is missing a </Ribbon> tag. Funny thing is that this exact sample XML code is on at least 5 other websites. Looks like a bad example of copy/paste. So, I may toy around with it some more, and put the XML code for the ribbon I have developed, and put that in the USysRibbons table, and see what happens. " Also, the last post may be of interest: " Re: Disabling Ribbon Bar Hi, I found in the Access 2007 a "How to" page that discloses the cleanest way to get rid of the ribbon altogether and display your custom menu and toolbars. Go to "Developer Help" - "How Do I" - "Miscellaneous". The key item I got is that in the mdb's startup options, you *must* select the name of your custom menu bar and persist it to the database using Access' startup options window. And you must have the "Allow Full Menus" and "Enable Built In Toolbars" options set to off. These options must have been set *before* your mdb is opened in Access 2007. Through trial-and-error (as you did), I found that it is not enough to set the startup menubar on the fly with VBA code. I do, however, use VBA to display my desired toolbars. All of this is without the existence of the USysRibbons table. But to be complete in sharing, I do have the Sys table but have the ribbon name cleared in Access 2007 startup options." Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Thursday, November 01, 2007 12:57 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Office 2007 Ribbon Bars Um ... Office/2006?? Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Thursday, November 01, 2007 9:15 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Office 2007 Ribbon Bars John, Got this, but I haven't tried it: For those of you who want to completely get rid of the ribbon--here are the steps: 1. Create a new table called USysRibbons. 2. Add two fields RibbonName (text) and RibbonXML (Memo). 3. Create a new record with the name "Blank" (doesn't really matter what you call it). Also add the following XML: <CustomUI xmlns="http://schemas.microsoft.com/office/2006/01/CustomUI"><Ribbon startFromScratch="true"/></CustomUI> 4. Restart your database. 5. Go into the Office Button | Access Options. Click on the Current Database. 6. In the Toolbars Option set the Custom Ribbon Id to Blank (name in step 3). 7. Restart the database. HTH, Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, November 01, 2007 8:44 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Office 2007 Ribbon Bars I haven't been following the subject, and I am wondering if anyone has discovered a workaround to get rid of the new ribbon bars and get back the standard office menus that look and feel like 2003? I have a couple of customers with databases designed (crammed into) an 800x600 format back when the average monitor was a 14". Even though they purchased newer 17" monitors all the users are griping so bad about 1024 x 768 that the owners are caving in and staying at 800x600. Thus there is NO room for the newfangled toolbars. If they are going to upgrade they will have to keep the old menus or at least turn off the ribbon bars. I can do custom menus if those are still available, but the ribbon bars have to go. John W. Colby Colby Consulting www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com