Solved

Access 2010 Ribbon and Custom Menu

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

867 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

16 Experts available now in Live!

Get 1:1 Help Now