Solved

Custom menu bar Access 2010

Posted on 2011-09-08
6
729 Views
Last Modified: 2012-05-12
Experts,
Now that we've move to the ribbon concept I would rather create traditional menu bars in Access. Possible? If so, how?
0
Comment
Question by:Frank Freese
  • 3
  • 2
6 Comments
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 425 total points
Comment Utility
Not in A2010.  I'm not aware of any tool to do so, SADLY.  You can still create them in A2003 then convert or run in A2010 ... of course a major PITA.

But .. there is some good news ... this:

http://www.accessribbon.de/en/

To create custom ribbons ... this is the Go To Site for Ribbon info.

mx
0
 

Author Comment

by:Frank Freese
Comment Utility
mx,
Not exactly the answer I was hoping for(rats!). I've using Access 2010 at this time for setting up my tables and relationships in an Access 2003 format since that is what version (2003) this company uses. Sounds like once I get the tables completed I need to move the database to a 2003 platform. Any problems here?
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 425 total points
Comment Utility
Not the answer ... I couldn't agree more. It's totally bogus.  And worse, other than with vba code (or possible with USysRibbons) ... there is no TOOL to create custom Right Click Menus !!!!!!  Not Acceptable.  Even on the DE site ... no tool ... yet.

"Sounds like once I get the tables completed I need to move the database to a 2003 platform. Any problems here?"

Well ... tables only ... should ... not be a problem.

mx
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 75 total points
Comment Utility
Actually in Access 2007/2010 you can still work with the menu bars via VBA code. The disadvantage is the menu bars only show on the add-in tab.

The Ribbon still has some way to go in the customization area.

The UI I like to use now in place of a menu bars is a side menu. Using the tree view control or the Explorer Style.



 

0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 425 total points
Comment Utility
"The Ribbon still has some way to go in the customization area."
Quite the understatement ....  :-)

Yes ... of course VBA code.  I was referring to the wonderful (seriously) Customize dialog for custom menus/toolbars and Right Click menus in A2003 and prior.

mx
0
 

Author Closing Comment

by:Frank Freese
Comment Utility
thanks
0

Featured Post

Backup Your Microsoft Windows Server®

Backup 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.

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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.

762 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

5 Experts available now in Live!

Get 1:1 Help Now