[AccessD] 'Find' inconsistent

A filter will handle complex expressions -- no need to do one and then the other -- just do them all with the filter. ADO Find can't handle And and Or. 

Susan H. 
  ----- Original Message ----- 
  From: Arthur Fuller 
  To: accessd at databaseadvisors.com 
  Sent: Wednesday, February 19, 2003 4:35 PM
  Subject: RE: [AccessD] 'Find' inconsistent


  I have used it extensively without problems. Perhaps you are referring to inconsistencies between DAO's many FIND commands and ADO's single command? For example, you can't find on a complex expression. You have to find on one expression then filter the result set on the rest of the expression. At least that's the only thing that worked for me. 



  -----Original Message-----
  From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Mark Boyd
  Sent: February 19, 2003 3:23 PM
  To: AccessD at databaseadvisors.com
  Subject: [AccessD] 'Find' inconsistent



  I'm using Access2000, and am having a problem finding records when using the 'Find' command.

  I remember reading somewhere about an inconsistency with finding the correct records.

  Is there a service pack that resolves this issue (Access, Jet, MDAC)?

  Any help is greatly appreciated



  Thanks,

  Mark Boyd

  Sr. Systems Analyst

  McBee Associates, Inc.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030219/4d168fdd/attachment-0002.html>