Solved

Access 2010 Ribbon and Custom Menu

Posted on 2013-11-18
3
714 Views
Last Modified: 2013-11-22
Hi,
I am trying to convert and Access 2003 database to an Access 2010 database.    The issue is that the Access 2003 database has a custom menu bar that I need to include in Access 2010.  I know it generally comes in as an Add in in the ribbon but I do not want users to have access to anything other than the custom menu bar.  

I read online that I need to hide the ribbon in order to prevent access to the Quick Access Toolbar but I can't seem to hide the ribbon and use the custom menu bar from Access 2003.  

What is the best way to display the custom menu bar from 2003 while hiding the ribbon and quick access toolbar?

Thanks,

Josette
0
Comment
Question by:oneiljk11
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 39657359
How to render the Ribbon File Tab useless:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27231448.html

See my posts toward the bottom of the tread ... with XML for USysRibbons table, etc.

Note ... this does not work in A2013 FYI ... custom menus will show only on the Add-Ins ribbon. So,  A2010 is it ... to be able to do this. At least, so far no one has found work around.

Bottom Line
Start creating custom ribbons and let the legacy menu bars go.  I had to do this.

mx
0
 
LVL 75
ID: 39657364
Meanwhile ... everything Ribbon is here:

http://www.ribboncreator2010.de/

Get this tool - de-facto standard for creating custom Ribbons.
And there is a LOAD of great ribbon stuff on the site, including about 30 mdbs with Ribbon examples.
0
 

Author Comment

by:oneiljk11
ID: 39669249
Thank you for the information.  I was able to do what I needed by changing the file extension to accdr.

I will have to start working on a custom ribbon.

Thanks.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question