I have a Access-1997 database. I use custom Menubars, Toolbars. Thus hiding all default menu/toolbar options and restricting users' choices to these customized bars.
I now want to upgrade this databse to Access-2010, and want to replicate the same custom bars with ribbons.
I have created 5 new/custom tabs on the Ribbon-Bar.
Depending which form/report is open, I want the Ribbon-Bar to show only the pre-defined tabs.
I know how to hide the ribbon bar (using: DoCmd.ShowToolbar "Ribbon", acToolbarNo). But now I want the Ribbon-Bar to be visible but only showing my selected tabs.
Is this possible?
In short, how to replicate the behavior of Access-1997 customized menus/tools into Access-2010?