Customize Menu

(1) I'm using Access 2016 , what I want is to use the old menu for 2003 , I can find some some link under the following:

(1) Menu -------------------- Tools  drop down  , here I can see a similar menu like the 2003 Access , but the most wanted one CUSTOMIZE

I do not seam like finding it , I need this one for the purpose of creating my own profession look menu.For sure this will be Achieved by using either VBA or macros to link forms.

(2) I have explored this issue of linking forms & reports using either the macros and VBA through the ON  ACTION  command property , but it looks like the way to link the forms or reports is to create some functions like below:

Public Function OpenForm(strform As string)
On error resume next
DoCmd.OpenForm strform
End function

Now is there a way to amend the function so that I do not just open one form , it should be used to open many forms , otherwise it will mean writing over a hundred functions , I have also explored the macro way , there is also no way out each macro must have its name specifically to accomplish a certain tusk.


Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
Those menus are gone. You are left with the ribbon, which you'll have to customize. That is set up via XML files, which only in theory are possible to modify manually.

Your best bet is to spend the few bucks on RibbonCreator: WYSIWYG Ribbon Editor
Also, note the tool: CommandBars Converter


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Fabrice LambertConsultingCommented:

There is a free ribbon creation wizard available.
Even tho, the web site is in french, the application support both french and english languages (go to "Options" tab, and "Langue" dropdown):
Dale FyeOwner, Developing Solutions LLCCommented:
and if you are interested in the right-click (shortcut) menus, take a look at some of my articles:

Understanding and using command bar (shortcut) menus Part 1
Understanding and Using Commandbars (Part II)

Or checkout the Access Shortcut Tool
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
HIGHLY recommend Gunter's Ribbon Creator and Dales's Access Shortcut Tool.  I use them both often.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.