Solved

Access 2010 Ribbon and Custom Menu

Posted on 2013-11-18
3
734 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 - Microsoft MVP, Access and Data Platform) 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

733 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