Re: How to use LIKE operator with Filter prop of recordset for num fie

Tech-Archive recommends: Fix windows errors by optimizing your registry

Ivan wrote on Thu, 9 Mar 2006 07:10:31 -0800:

and datetime fields.

Is it possible to organize a 'quick search functionality' in the table by
meanse of the Filter prop. I wouldn't like to requery. Filter works
faster. Can someone give me examples for numeric and date fields?

Thanks in advance.

A look on Google for

ado filter

turned up this:

http://www.devguru.com/technologies/ado/QuickRef/recordset_filter.html


Looks pretty simple to use LIKE. However, LIKE is only for strings (which is
also true of the T-SQL LIKE in SQL Server). What exactly are you trying to
do?

Dan


.

Relevant Pages

  • RE: VBA record filtering and filterOn property
    ... I would store the current record position before the requery, ... sort order is the same and no new records were added in the meantime. ... Because I display the Access navigation buttons on my form, I had to filter ...
    (microsoft.public.access.formscoding)
  • RE: VBA record filtering and filterOn property
    ... I would store the current record position before the requery, ... Because I display the Access navigation buttons on my form, I had to filter ...
    (microsoft.public.access.formscoding)
  • Re: Resetting subform filters
    ... I was wondering if you could force a requery ... Not requerying - it isn't necessary when I change the filter, ... The recordsource on both subforms is set to a table - not a query or ...
    (microsoft.public.access.forms)
  • Re: Removing filter loses bookmark
    ... filter, change the sorting, change the RecordSource, or requery the form. ... the first record becomes the default? ... before I reset the form's recordsource, and then in the ontimer event, I ...
    (microsoft.public.access.formscoding)
  • Re: Value with Record change
    ... trigger that requery. ... > cbo_2 is fed off of a query that has cbo_1 set as the filter criteria. ... > the options in cbo_2 will change depending on the value selected in cbo_1. ... > It only filters if I make a current selection. ...
    (microsoft.public.access.formscoding)