Re: [MS_AccessPros] Convert Ribbon from Access 2007 to Access 2016

 

Domenico-

The way I've always handled Ribbons it so define a custom USysRibbons table.  It has three simple fields:

ID - AutoNumber

RibbonName - Text 255

RibbonXML - Memo

Note that this is a System Table because of its name, so you need to Show System Objects in Navigation Options to see and work with it.  After you create this table and reopen the database, Access automatically loads all the Ribbons you've defined to make them available to the rest of the application.

Any Ribbon you define in this table you can set as the application Ribbon in Options / Current Database.  You can also use the Ribbons you've defined as the Ribbon Name property for Forms and Reports.

You can read more about using this technique here:

https://support.office.com/en-us/article/Customize-the-Ribbon-45e110b9-531c-46ed-ab3a-4e25bc9413de

You can download a sample database from my 2007 book that demonstrates this technique here:

ftp://ftp.viescas.com/Downloads/Contacts2007.zip

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On Sep 23, 2016, at 11:49 AM, domcoz@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hi, Friends

I have an application in access 2007 that works always, in the application I have a ribbon that the load from a text file, I'm trying to pass it to Access 2016, but do not see it ... I see only the Access ribbon.

Where am I doing wrong??

Thanks a Lot

Domenico

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___