icons

  • Thread starter Thread starter Nathalie
  • Start date Start date
N

Nathalie

I would like to put the "Filter by form"-icon directly on
the form so that the users do not have to look at the
Form Toolbar to search the icon.

When I try to make a button there is no option
for "Filter by form". I can find the "Edit filter"-button
but when you click on that button, a query will be
opened. I don't want users to make a query, I want the
users to fill in criteria as with de "Filter by Form"-
button in the toolbar.

Is that possible?

Thank you.
Nathalie
 
Nathalie,
Right-click on any toolbar.
Select Customize.
Click on the Toolbars tab. Select New.
Name this Toolbar 'RecFilter'.
Click on the Command tab.
Find the Records category in the left panel.
Select the Filter By Form toolbutton in the right-panel
and drag it onto the new 'RecFilter' toolbar.
Next find the Apply Filter toolbutton and drag it onto this toolbar.
Close the Customize dialog.

Next open the form in Design View.
Code the Form's Load event:
DoCmd.ShowToolBar "RecFilter", acToolbarYes

Code the Form's Close event:
DoCmd.ShowToolBar "RecFilter", acToolbarNo

Open the form.
Move this toolbar to an accessible area on the form.
Close the form.

Now whenever this form is opened the toolbar will
appear in that spot, unless moved.
You can prevent the user from moving the toolbar
by going back to the Customize dialog.
Click the Toolbars tab. Highlight the RecFilter toolbutton.
Click Properties and uncheck the Allow Moving box.

Hope this helps.
 
Back
Top