Modifying the Ribbon in Access (using VBA)

Andy Brown
Andy Brown used Ask the Experts™
on
I really need some pointers with the Ribbon within Access 2016.

Ideally, I want a single, customisable bar only along the top for my application.  I don't need the "Quick Access toolbar" or multiple Ribbons (with their tab headings) etc., as my application requires as much screen space as possible - with only few user functions along the top.

I would prefer to still use a single ribbon for my functions (rather than cobble together my own buttons, which never look as good) - but all of the other stuff is not required.

Any ideas
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Owner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
Commented:
Andy, you can no longer create commandbar menus for your forms, but you create your own ribbons using the tool available here.

Another option would be to place a couple of command buttons in your form header and have the click event of those raise shortcut menus, this is a technique I use often.  I have written three articles on how to create and use shortcut menus here in EE (search for "Commandbar", then check the Articles checkbox).
Andy BrownDeveloper

Author

Commented:
Great stuff - thank you so much for the help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial