[AccessD] Turn off the ribbons programmatically

Rocky,

  Here are some instructions I found (not sure where) for turning off the
ribbion.  I believe I posted them once before and someone said they didn't
work, but you might want to give it a try anyway.

HTH,
Jim. 

# re: Customizing the New Access UI 
Friday, July 14, 2006 6:15 PM by clintc 
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. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Wednesday, December 03, 2008 11:51 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Turn off the ribbons programmatically



Dear List:
 
Is there a way to turn off the A2007 ribbons programmatically?  In a way
that will not cause the program to barf if it's being run by A2003?
 
I have a legacy 2003 app that's run by the client on 2007.  The ribbon takes
up so much freakin' real estate that you can't see the whole form on the
display.  Especially the exit button at the bottom which is kind of
important. 
 
I got the navigation pane to turn off: DoCmd.RunCommand acCmdWindowHide, but
not the ribbon.
 
MTIA
 
Rocky

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com