Anita Smith
anita at ddisolutions.com.au
Tue Apr 29 19:17:25 CDT 2014
Ok this is the crux of the method. A system table USysRibbons (that you create yourself - or copy form the link below) holds the Ribbon Info. You have to enable viewing of system objects in the Options/Current Database/Navigation to see this table. This table has 3 fields ID RibbonName RibbonXML Once this table is in the database it is automatically loaded when the program loads and the ribbons within it can be used on forms and reports. I have two ribbons in mine - one that essentially hides the normal ribbon and a print preview ribbon. As for the XML it is not too hard to suss out once you have a sample to look at. Anyhow here is the link to the file download where you can see this demonstrated: http://www.kallal.ca/msaccess/DownLoad.htm The one to get is - Access 2007 report ribbon example (with PDF and email). I had to do it a bit differently as I have an adp with SQL server back end - I had to create a regular sql table and load the ribbons with code manually - not too hard but a little more work. Anita Smith -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Wednesday, 30 April 2014 9:52 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Ribbon Hi Anita: Please do. :-) Jim ----- Original Message ----- From: "Anita Smith" <anita at ddisolutions.com.au> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Tuesday, April 29, 2014 4:47:38 PM Subject: [AccessD] Ribbon Hi fellow earthlings, While solving a problem one of my users have encountered after updating to Access 2010 runtime I came across some nifty ribbon shenanigans that I have filed under useful stuff. Her problem was that the Access 2010 runtime Print Preview toolbar was missing exports to Word and Excel among other items. I had no option than to dive into research on how to solve this highly annoying 'feature'. Anyhow - I came across a way to quickly create custom ribbons using a system table and XML. In no time I had a new Print Preview Ribbon up and running and as an added bonus I also got rid of the main ribbon for the whole application using this method. As I have not had time to read and follow all AccessD threads, I don't know if this is common knowledge here. Anyhow - I'll be happy to elaborate further should anyone have a need. Anita Smith -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com