Menubar Access 2013

I'm using Access 2013 and am still using menubars created in 2003.
I want to be able to load my menubar without clicking Add-ins.
Does anybody have a workaround?

This is according to the official blurb, but doesn't work:

When opening a database in Microsoft Access 2013 that was created in an earlier version of Microsoft Access, the specified menu bar will be displayed differently depending on the curent settings of the AllowFullMenus and AllowBuiltInToolbars properties. If the AllowFullMenus and AllowBuiltInToolbars properties are set to False, the specified menu bar will replace the ribbon as the default set of commands available to the user. If the AllowFullMenus or AllowBuiltInToolbars property is set to True, then the specified menu bar is displayed on the ribbon Add-Ins tab.
LVL 46
Who is Participating?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
I assume you are still running in MDB format?
In A2010, it was possible to only have your original menu bar - no File or Add-Ins tab.  However, it seems the behavior has been changed in A2013.

 I have a couple of dbs open in A2013 right now - that work perfect in A2010, and sadly - the File and Add-Ins tab is showing.
In fact, the Home tab is also showing, however I pretty sure I can get rid of that by using the USysRibbons table.

So, I'm not going to state yet that it's not possible, but it's not looking good. To date, no one I'm aware of has been able to get rid of the File tab in A2010 - IF - you are using the ACCDB format and your original menu bars - or just a custom ribbon.

I am now spending a LOT of quality time with this tool:

... which is the de-facto standard tool for creating custom ribbons.  Gunter also has a CommandBar Converter tool (free >> ) ... which will convert your A2003 menu bar into a custom ribbon.  If you get these tools ... be SURE to take a couple copies of your dbs - and see what all the different options in the tools do - it, get used to the tools and how they work, which for the most part - is pretty good.

I'm afraid you (like me) are going to have to pull the plug on menu bars and get hip to the Ribbon. That's been my main focus the last 3 weeks.

The only other Ribbon tool is  Avelino's tool .  I also bought this ($25). It's a different approach, more of a 'learning tool'. I've exchanged several emails with the developer, but ... I'm finding this tool a bit tedious to use. He has some videos, but unfortunately - they were done in A2007 Ribbon, thus are a bit confusing to follow in A2010, as well as parts (labels, etc) being in a different language (Portuguese) .

Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
None that I'm aware of....with A2013, your pretty much forced into the ribbon.

Let's see if anyone jumps in with something else though...

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
btw ... Gunter also has a 2013 version of the Ribbon Creator. Also, the is a LOAD of ribbon info on his site, including about 25 sample dbs with different aspects of the Ribbon, all of which I downloaded.
tbsgadiAuthor Commented:

"Gunter also has a CommandBar Converter tool (free >> )"

System Requirements

The CommandBars Converter requires an installed and registered version of the IDBE Ribbon Creators2010.
If only a shareware version of the IDBE Ribbon Creator 2010 is installed, the CommandBars Converter 2010 can not be started.

Looks like you have to buy Creator to use the free Convertor.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Correct. That's because the work together. You convert, then open in RC.
Note: If you have custom command bars and you are using the OnAction property, this is not converted.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.