Re: Waiting for a recordset to finish fetching

But, yeah, the point is that my theory is that ADO is still working on
building the recordset at the time the find executes.

How? Only if asynchronous.

If it Client-Sided and not asynchronous, it is never true.
Open() will not be returned from early.
Only when the last record is loaded will Open() return.

If it is Server-Sided, Find() does not work well AFAIK.
I am not even sure what it does.
Some day I will make some tests to find out.
Find() could, in theory, only work on the portion of the Recordset loaded in
memory.
Remember Server-Sided cursors are very very different from Client-sided.
For Server-Sided cursors, ADO is just a thin layer over what the database
provides.

Things like Filter, Sort, Find are designed to worked on client-sided
recordsets because all records are available in memory.
For server-sided recordsets you should use the SQL WHERE clause and ORDER BY
clause to do filtering, sorting, finding

My guess is you do have Server-sided cursor and are getting unpredicatable
results from Find().
Best bet is to change the CursorLocation to Client-sided.
Find() will work correct after that.

Stephen Howe


.

Relevant Pages

  • Re: Access SQL
    ... If so, then create a filter ... will leave the recordset of the form editable. ... You'd then write an appropriate SQL WHERE clause and you can either ... The statement inside the IN is a full SQL statement returning one ...
    (comp.databases.ms-access)
  • Re: Find without a recordset?
    ... put into a WHERE clause to filter in the SQL Server before the recordset is ... This is financial processing, ... >>That's the point of filtering with a WHERE clause. ...
    (microsoft.public.sqlserver.programming)
  • SQL syntax from Filter by Form
    ... I am trying to print a dynaset obtained from a Filter by Form. ... OpenReport fails if the resulting recordset is too big. ... The where clause is ...
    (microsoft.public.access.formscoding)
  • Re: producing a report based on filter criteria...
    ... Remove the "Lookup_fname" from the filter property prior to using the form's ... > filtered recordset. ... > 'filter' value as a 'where' clause to print the report. ...
    (microsoft.public.access.reports)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... in the criteria cell in the graphical query builder. ... use as the source in the routine. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ...
    (microsoft.public.access.formscoding)