Kevin
thewaddles at sbcglobal.net
Wed Mar 24 21:47:23 CDT 2010
Doug, Thanks for the quick response. I've got that part. I have the following code in the OnCurrent Event for each form... If RegistryGet("EF Database", "Login", "Initials") = "ADMIN" Then Me.RibbonName = "Admin" Else Me.RibbonName = "User" End If This puts the Ribbon on the Ribbon Bar but does not activate it. I would like to make my custom tab active when a form is selected. Thanks, Kevin Waddle thewaddles at sbcglobal.net God never gives us discernment in order that we may criticize, but that we may intercede. -- Oswald Chambers -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: Wednesday, March 24, 2010 6:56 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Ribbon Set Focus (Cross Posted - AccessD and Access-L) Set that property on forms and reports. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kevin Sent: Wednesday, March 24, 2010 6:50 PM To: 'Access Developers discussion and problem solving'; ACCESS-L at PEACH.EASE.LSOFT.COM Subject: [AccessD] Ribbon Set Focus (Cross Posted - AccessD and Access-L) Hello, I finally bit the bullet and am customizing the ribbon. I figured out how to assign a different ribbon to each form and how to assign a different ribbon to the same form based on user login. What I can't find, tried Google and Archives in both lists, is how to programmatically activate.setfocus.a specific ribbon. Has anyone figured this out? TIA, Kevin Waddle <mailto:thewaddles at sbcglobal.net> thewaddles at sbcglobal.net Do not pray for easy lives. Pray to be stronger men! Do not pray for tasks equal to your powers. Pray for power equal to your tasks. - Phillip Brooks -- 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