Results 1 to 5 of 5

Thread: ADO Find Method Error

  1. #1

    Thread Starter
    Fanatic Member Jumpercables's Avatar
    Join Date
    Jul 2005
    Location
    Colorado
    Posts
    592

    ADO Find Method Error

    I have populated my access table with all the information, and now I am trying to find a record in relationship to a string however everytime I try to find I get an error:
    Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
    I have tried to move to the first record but still get the same error. The type in the table for this field is of text.

    DefaultId = "MS-10003"
    It is located in the table, but I am not sure why I am getting the error, any ideas?

    VB Code:
    1. adoRs.MoveFirst
    2. adoRs.Find "STATION ID='" & DefaultId & "'", , , 1

    C# - .NET 1.1 / .NET 2.0

    "Take everything I say with a grain of salt, sometimes I'm right, sometimes I'm wrong but in the end we've both learned something."
    _____________________
    Regular Expressions Library
    Connection String
    API Functions
    Database FAQ & Tutorial

  2. #2
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901

    Re: ADO Find Method Error

    I think you need ()

    Find (criteria, SkipRows, searchDirection, start)

  3. #3

    Thread Starter
    Fanatic Member Jumpercables's Avatar
    Join Date
    Jul 2005
    Location
    Colorado
    Posts
    592

    Re: ADO Find Method Error

    Pretty sure I tried that, but lets give it a shot

    C# - .NET 1.1 / .NET 2.0

    "Take everything I say with a grain of salt, sometimes I'm right, sometimes I'm wrong but in the end we've both learned something."
    _____________________
    Regular Expressions Library
    Connection String
    API Functions
    Database FAQ & Tutorial

  4. #4

    Thread Starter
    Fanatic Member Jumpercables's Avatar
    Join Date
    Jul 2005
    Location
    Colorado
    Posts
    592

    Re: ADO Find Method Error

    no dice

    C# - .NET 1.1 / .NET 2.0

    "Take everything I say with a grain of salt, sometimes I'm right, sometimes I'm wrong but in the end we've both learned something."
    _____________________
    Regular Expressions Library
    Connection String
    API Functions
    Database FAQ & Tutorial

  5. #5
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901

    Re: ADO Find Method Error

    Which cursor are you using? I think you need a server side cursor to use Find.

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