Re: Newbie filter question

From: Wart (nospamWart_at_epix.net)
Date: 10/07/04 

Date: Thu, 7 Oct 2004 09:31:21 -0400

RecSet.Filter = "(field1 <> '" & ListBox1.Value & "')" ???
"Dave F." <df@bh.com> wrote in message
news:uxUFpnGrEHA.2580@TK2MSFTNGP15.phx.gbl...
> Hi
> I'm using ado within a vba routine.
> I have a recordset that I want to filter.
> I can get it to display all that meet the criteria:
>
> RecSet.Filter = "(field1 = '" & ListBox1.Value & "')" ' filters rset to
> return all ub's etc
>
> But is there an easy way to filter out the criteria & just display the
> rest?
>
> Something like NOT?
>
> Any help would be appreciated
>
> Dave F.
>
>

Relevant Pages

  • Re: other table that stores data differently than ADO.Net datatable?
    ... >> would suggest making some sort of a "search" type of screen and filter ... >> criteria for your where clause, that will help slim down your list. ... >>> query the database everytime the user does a scroll (or page up/page ... >>> will display the next N records once the user has reached the last ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: data filtering based on last two digits of large number
    ... The double-negative-operators are necessary in that form of the criteria. ... filter, copying the good cells to a new range and then cutting them out ... All of the valid records, where the date/time values end in 53, will be ... Data|Filter|Show....to display the remaining valid rows ...
    (microsoft.public.excel.worksheet.functions)
  • Re: problem with filter
    ... user can enter the criteria into unbound controls in the Form Header ... Incorrect display of data ... My forms are designed in a way that the user can filter by using ...
    (microsoft.public.access.forms)
  • Re: pulling data from an excel workbook
    ... Dave, ... filter based on the criterion in all the columns. ... How could the hard coding in the range for the "criteria ... dim myRng as range ...
    (microsoft.public.excel.programming)
  • RE: Autofilter Not working completely
    ... Have several workbooks which were built alike. ... once a criteria is selected, will display only those rows that match the ... for some reason two of the workbooks don't filter all the data. ...
    (microsoft.public.excel.misc)