Kemp's Case Works, Inc.

- Customization - Complex

Microsoft Access 2007 and 2010 allow for the customization and creation of ribbon bars for use in various forms.  A good example is the client search screen.  A good approach to creating a ribbon bar is contained in a Microsoft article located here.  You can follow the instructions for creating the ribbon bar there.

For some good search options in your toolbar, you can substitute the following:

Ribbon name: Search Screen

RibbonXML:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
    <ribbon startFromScratch="true">
        <tabs>
            <tab idMso="TabCreate" visible="false" />
            <tab id="dbSearchtab" label="Search Tab" visible="true">
                <group id="SearchScreenSort" label="Sort and Filter">
                    <box id="myBox1_h" boxStyle="horizontal">
                    <toggleButton idMso="SortUp" />
                    <toggleButton idMso="SortDown" />
                    <button idMso="SortRemoveAllSorts" />
                    <toggleButton idMso="FiltersMenu" />
                    <menu idMso="SortSelectionMenu" />
                    <button idMso="FilterClearAllFilters" />
                    <toggleButton idMso="FilterToggleFilter" />
                    <toggleButton idMso="SortAndFilterAdvanced" />
                    <menu idMso="FilterAdvancedMenu" />
                    <menu idMso="WindowsSwitch" />
                    </box>
                </group>
            </tab>
        </tabs>
    </ribbon>
</customUI>

You may want to use this search screen ribbon ONLY in the search screens.  (And not apply it to all pages.)  Open a search screen, in the properties for the form, under the "Other" tab, choose the Search Screen ribbon in the "Ribbon Name" property.