[AccessD] Office 2007 Ribbon Bars

This site has several suggestions on the ribbon. I normally turn off Access 
menus and use my own, and used the "Want my databse created in A2003 do 
display my own menubar only"  from URL  below.

http://www.accessribbon.de/en/index.php?FAQ#VerweisError

I added notes that may or may not be useful but include them anyway.

>From my personal Tech-Tips.

NOTE: does not remove ribbon the first time, must close and reopen??? 5/07

(Not needed on mine because done in open routine)
Remove the tick from:

A2003: "Tools" / "Startup" / "Allow Build-in Toolbars"

Select your menubar from the drop-down "Menu Bar"

Click on main menu, then select Access Options at the bottom Then current 
database and scroll to the Ribbon and tool Options

 A2007: "Office Button" / Button "Access Options" / "Current Database" / 
"Ribbon and Toolbar Options" / "Allow Build-in Toolbars"

Select your menubar from the drop-down "Menu Bar".

Unclick allow built-in toolbars
Click Allow full Menus and allow Default Shortcut Menus
Note I can set the CurrentProject.Properties.Add "AllowBuiltinToolbars", 
True to false
Key Words
Remove Ribbon from  2007






----- Original Message ----- 
From: "jwcolby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Thursday, November 01, 2007 5:43 AM
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