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
..