Results 1 to 5 of 5

Thread: ADO Seek Method

  1. #1

    Thread Starter
    Member
    Join Date
    Mar 2001
    Location
    India
    Posts
    34

    Resolved ADO Seek Method

    I am new to ADO , with DAO after seek i used to check if seek is success or not with "IF NOMATCH Then" but with ado nomatch doesnt work. what can i use to check if matching record has been found or not?

    Hitu
    Last edited by Rob3161; Apr 24th, 2006 at 03:28 PM.

  2. #2
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385

    Re: ADO Seek Method

    If you use SQL... Then no records would be returned. If you are working with a recordset use the filter command.

  3. #3
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: ADO Seek Method

    If Seek does not find the desired value, EOF will be set to true.

    VB Code:
    1. rs.Seek "SomeValue"
    2. If rs.EOF Then
    3.   'Seek did not find a record
    4. Else
    5.   'Seek found a record
    6. End If

  4. #4

    Thread Starter
    Member
    Join Date
    Mar 2001
    Location
    India
    Posts
    34

    Re: ADO Seek Method

    Yes , rs.EOF works fine , that is what i wanted... thanks guys

  5. #5

    Thread Starter
    Member
    Join Date
    Mar 2001
    Location
    India
    Posts
    34

    Resolved Re: ADO Seek Method

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width