[AccessD] Office 2007 Ribbon Bars

Hi Jim

No cigar here. Neither with 2006 replaced with 2007.

/gustav

>>> jimdettman at verizon.net 01-11-2007 17:15:11 >>>
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