Rocky Smolin
rockysmolin at bchacc.com
Tue Dec 8 07:52:24 CST 2009
Ack. I was afraid of that. I don't want to mess with it at all because then I have to fire up 2007 on machine 2 and actually use it. But the add in looks to be not too painful. Tks. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: Tuesday, December 08, 2009 12:25 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Controlling the Ribbon Rocky You might have to create a custom ribbon containing your commands and then turn it of and on. http://www.microsoft.com/downloads/details.aspx?familyid=291704cb-655a-491f- 8089-566be7d2e9b0&displaylang=en http://word.mvps.org/FAQS/Customization/CustomizeRibbon.htm martin Martin WP Reid Information Services The Library at Queen's Tel : 02890976174 Email : mwp.reid at qub.ac.uk Sharepoint Training Portal ________________________________________ From: accessd-bounces at databaseadvisors.com [accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin [rockysmolin at bchacc.com] Sent: 08 December 2009 01:16 To: 'Access Developers discussion and problem solving' Subject: [AccessD] Controlling the Ribbon Dear List: I have these canned routines ShowRibbon and HideRibbon, which is DoCmd.ShowToolbar and work well. I also have MaximizeRibbon and Minimize Ribbon which use SendKeys "^{F1}" to change the ribbon but they don't seem to work. In any event, the user wanted a local preference to show or hide the Ribbon and ShowRibbon and HideRibbon work except that instead of the ribbon disappearing he wants to have the smaller ribbon with the Office Button and Home, Create External Data, Database tools showing but nothing else - so a ribbon that's not so tall and screws up the real estate on the form. But I can't get that particular ribbon format to display. Does anyone know how to get that? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.com/> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com