Re: Advanced filter method


"sandokan" <javi_s@xxxxxxxxxxx> wrote in message
news:db5arm$unv$1@xxxxxxxxxxxxxxxxxxx
> Due to the "Filter method" limitations (can't apply filters to compare
> dateparts -> I want to filter all the records of a month, can't use the
> clausule "NOT LIKE", ...), I want to use a more complex method to filter
> records. Does anybody knows how can I do it without reload all the recods
> from the database? I thought in save the recordset as XML and later query
> it with a new sql, but is impossible to query a disconnected recordset or
> open the XML as connection and open the recordset thru a SQL query.
>
> Has anybody any idea about how can I do it?. I need a complex filter
> method and I don't want to reload all the 100,000 records!!!
>
> Thank you and sorry about my english


One trick is to derive the date parts in SQL as calculated fields, making
them available to your filters. Basically, you can make-up for the limits
of filter with a little forethought and some creative derivations on the SQL
side.

-Mark


.

Relevant Pages

  • Re: Loading recordset at runtime
    ... difference in loading time for the entire recordset and the default 10 ... query or build the SQL string in VBA. ... Ah, ok, then use the forms "filter" option. ...
    (microsoft.public.access.forms)
  • Re: Change a query that a form is linked to based on some controls
    ... I have the SQL for this (from the query window) - ... I'm wondering if building the filter seperately ... To refer to the form in the subform control: ... If you prefer, you can build the entire SQL string, and assign it to the ...
    (microsoft.public.access.formscoding)
  • Simple Access SQL Query?
    ... executing this query does NOT make it the source for your ... So, after executing your query, your form continues to ... Filter By Form menu button to enter the criteria, ... learning Access SQL, ...
    (microsoft.public.access.queries)
  • Re: Equivalent of Get Next Extended to retrieve only unique keys?
    ... Do you know of any good resources for the ins & outs of accessing a btrieve database through SQL to supplement Pervasive's documentation? ... sort by various columns of data and to also filter on the columns. ... doesn't contain dozens of entries for the same patient. ... level of duplication is low, then perhaps you can do a regular GNE ...
    (comp.databases.btrieve)
  • Re: Searching
    ... MVP Access ... It would be best to build a filter string for the form ... click on the builder button for the RowSource property of your listbox and build the SQL -- use some criteria too. ... Dim mFilter As String ...
    (microsoft.public.access.queries)