Filter by Form - Access 2002

  • Thread starter Thread starter RFJ
  • Start date Start date
R

RFJ

There was an excellent utility written by Ken Getz for Access 97. It
essentially copied an existing input form and made it into a query form. You
could then enter criteria into each of the fields on the query form and the
records would be filtered accordingly.

Does anyone know if there is a public domain update or something similar
that has the same effect.

TIA

Rob
 
If you are using the Retail (not runtime) Access 2002, there is a Filter by
Form capability on the standard Form toolbar... looks like a funnel and a
form in the icon.

You'll still need your own, if you intend to distribute your app with
runtime support. I'd look for it in Litwin,Getz, and Gunderloy's "Access
2002 Desktop Developer's Handbook", but the Access 97 version shouldn't be
difficult to update.

(Paul Litwin told me that there would not be an Access 2003 edition of the
Developer's Handbook. If there is more change between versions for the next
Access version, perhaps the publisher will get them to do a new edition.)

Larry Linson
Microsoft Access MVP
 
Thanks Larry,

I do have the full retail version and thanks for point out the filter by
form icon on the toolbar.

Is there any way I can get that type of form into my application on a
permanent basis - eg as a form - so I can customise it/add it to a
switchboard, etc.

TIA

Rob
Larry Linson said:
If you are using the Retail (not runtime) Access 2002, there is a Filter by
Form capability on the standard Form toolbar... looks like a funnel and a
form in the icon.
Click to expand...
<cut>
 
Not exactly _that_ functionality, perhaps, but you can code a form that will
allow the user to select parameters/arguments defining which records to
display or print. It'll be up to you to apply that to some other Form or
Report. Frankly, I've never had data that needed a filter capability for
every single field.

You can start by making a copy of the updateable form to use as your
"filter" collector. Then you can delete whatever controls are for fields
that just don't make sense in a filtered selection.

Larry Linson
Microsoft Access MVP
 
Back
Top