[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/>