?
Solved

Access 2010 Ribbon and Custom Menu

Posted on 2013-11-18
3
Medium Priority
?
783 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

764 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