[AccessD] Ribbon

Anita et al,

I saw your reference to Albert Kallal in your post re Ribbon and 2010
Runtime; and recalled seeing a related post from Albert on UA yesterday. He
includes a link in his response that deals with ribbons for 2007 and 2010.
Here is the UA post that contains the link. I hope it's helpful to this
discussion.
http://www.utteraccess.com/forum/Deploying-Runtime-Quic-t2015574.html


On Wed, Apr 30, 2014 at 12:51 AM, Anita Smith <anita at ddisolutions.com.au>wrote:

> Bingo Stuart - that is exactly right (for regular Access databases)
>
> In an adp (connected to SQL server) there is no uSysRibbon table so a
> regular table is created in SQL Server. The ribbons are instead loaded
> manually when the application opens. Once loaded they are available for
> forms and reports and they may able to be manipulated at runtime too, I
> haven't tried that.
>
> Anita Smith
> DDi Solutions
> We Build Software!
> Custom Software, Websites & Databases.
> p: + 61 02606 72101 m: +61 040202 2462 | w: www.ddisolutions.com.au | e:
> anita at ddisolutions.com.au
> This Email message is for the sole use of the intended recipient and may
> contain confidential and privileged information. Any unauthorised review,
> use, disclosure or distribution is prohibited. If you are not the intended
> recipient, please contact the sender by reply Email and destroy all copies
> as well as the original message. All views expressed in this Email are
> those of the sender, except where specifically stated otherwise, and do not
> necessarily reflect the views of DDi Solutions.
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
> Sent: Wednesday, 30 April 2014 2:42 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Ribbon
>
> You misunderstand.  It's the developer that loads the ribbon that is
> appropriate to the Form/Report when building the system.
>
>  I just tried this in an old (cicra 2000) application that I am updating.
>
> I copied the usysRibbons table from one of the databases at Anita's link
> into the FE.
>
> Closed and reopened the application with the shift key held down so that I
> could see the Navigation panel.
>
> Opened a report in Design View
>
> Went to the report's Properties - Other - Ribbon Name.   The new custom
> ribbons were there
> in the drop down list.  I selected one and saved the report.
>
> Then I closed the application, opened it as normal and opened the report.
>  The custom ribbon was displayed.
>
>
> Magic - I am finally going to start using Custom Ribbons!
>
> Thanks Anita.
>
> --
> Stuart
>
> On 30 Apr 2014 at 0:24, Bill Benson wrote:
>
> > So... The user has to load the ribbon appropriate to each form/report
> > while using the database and as they tab from one to the other, the
> > ribbon for the last item they were viewing is what they are using by
> > default? Sounds not too user friendly if I am imagining this right.
> > Seems there ought to be a way to force each ribbon in code to what it
> > needs to show in the Activate event.
> >
> > If not, I won't use this.
> >
> > :)
> >
> > Thanks Anita!
> > --
> > 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>