Solved

Access 2010 Ribbon and Custom Menu

Posted on 2013-11-18
3
699 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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

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.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

757 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now