[AccessD] Ribbon

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