Access 2013 ribbon (1 Viewer)

JohnPapa

Registered User.
Local time
Tomorrow, 01:33
Joined
Aug 15, 2010
Messages
954
I would like to create in Access 2013 a simple ribbon with say 4 buttons:
1) A to Z sort
2) Z to A sort
3) Filter
4) Remove Filter

Can someone point me to a specific tool with which I can create this ribbon, to be used in specific forms. Also how do I include it in a form?

Thanks,
John
 
Last edited:

Ari

Registered User.
Local time
Today, 15:33
Joined
Oct 22, 2011
Messages
139
Hi

You can choose to load the group "Sort and Filter", as described in the XML code below:

customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="true">
<tabs>
<tab id = "tabForm" label = "Form" >
<group idMso = "GroupSortAndFilter" />
</tab>
</tabs>
</ribbon>
</customUI>


If you want to only four buttons, see how it is mounted, writing XML below:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="true">
<tabs>
<tab id = "tabForm" label = "Form" >
<group id="grFilter" label="Filter">
<toggleButton idMso="SortUp"/>
<toggleButton idMso="SortDown"/>
<button idMso="SortRemoveAllSorts"/>
<separator id="sp1"/>
<button idMso="ApplyFilter"/>
<button idMso="FilterClearAllFilters"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>

You should store the XML in tabel USysRibbons.
To access the ribbons properties through vba is necessary to add a class reference to Microsoft Office 15.0 Object Library .
In the list of properties for each form, indicate the name of the ribbon.
When you open the form the ribbon will load.

See more details in this article:

http://www.ribbons-access.com/ms-access/ribbon-creator-builder-and-editor-part-2.asp#inicio

..
 
Last edited:

Users who are viewing this thread

Top Bottom