<div>
If each tab is in its own ribbon definition, i.e. you can set the RIBBON NAME property of the FORM to the name of your ribbon. That ribbon will then be shown when your form is active.
</div>


If each tab is in its own ribbon definition, i.e. you can set the RIBBON NAME property of the FORM to the name of your ribbon. That ribbon will then be shown when your form is active.

<div>
Hey Anders ... welcome to Experts Exchange !
</div>


Hey Anders ... welcome to Experts Exchange !

<div>
As noted above ... if you are going to work with Ribbons. then Gunter's tool is a MUST have !<br />
<br />
mx
</div>


As noted above ... if you are going to work with Ribbons. then Gunter's tool is a MUST have !

mx

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I &nbsp;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.<br />
<br />
I now want to upgrade this databse to Access-2010, and want to replicate the same custom bars with ribbons.<br />
<br />
I have created 5 new/custom tabs on the Ribbon-Bar.<br />
<br />
Depending which form/report is open, I want the Ribbon-Bar to show only the pre-defined tabs.<br />
<br />
I know how to hide the ribbon bar (using: DoCmd.ShowToolbar &quot;Ribbon&quot;, acToolbarNo). But now I want the Ribbon-Bar to be visible but only showing my selected tabs.<br />
<br />
Is this possible?<br />
<br />
In short, how to replicate the behavior of Access-1997 customized menus/tools into Access-2010?
</div>
</div>


Hello,

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?

Access 2010 UI, Ribbons

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.