I am in the process of deploying a DB to clients. I need to run it with runtime as the clients may not have Access installed. I know that when I create it there is no ribbon anymore on the db I have a navigation menu so users can move around etc. but I need them to be able to filter some forms using the filter button on the ribbon and so am following instructions to create the ribbon using XML and the USysRibbon table. I only really need a filter so have created the following XML:
Code:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
<contextualTabs>
<tabSet idMso="TabSetFormReportExtensibility">
<tab id="MyTab" label="Form">
<group idMso="GroupClipboard"></group>
<group idMso="GroupRecords"></group>
<group idMso="GroupSortAndFilter"></group>
<group idMso="GroupFindAccess"></group>
</tab>
</tabSet>
</contextualTabs>
</ribbon>
</customUI>
which I hoped would create the relevant ribbon. I can open the database and select the custom ribbon, close the db and reopen and the default ribbon has gone but it shows none of my groups in fact no ribbon is shown at all. I have tried this with another db working trhrough the example on http://msdn.microsoft.com/en-us/library/bb187398.aspx and got the ribbon to work but using the examples they had which aren't what i wanted obviously. After I have this ribbon the way I want I then need to refer to this in the runtime version which I think is by using an autoexec macro but that will be another question when I come to it as I tried that before and had errors. All I want is a filter on the ribbon really on the packaged db but it just seems so complicated to do. Any help would be appreciated.