Results 1 to 3 of 3

Thread: recordset.find

  1. May 12th, 2013, 08:56 PM #1
    developerno1
    developerno1 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2005
    Posts
    305

    recordset.find

    hey im trying to find in a db table a columns with a couple of criterias.. but does the find command allow more than one of them?
    here's my code..
    Code:
    With rs_route
.Find ("stuid='" & stuid.Text & "' And bookid='" & bookid.Text & "' AND issuedate='" & dtp.Value & "'")
If .EOF = True Then
.AddNew
    how do i get this working
    Reply With Quote Reply With Quote
  2. May 12th, 2013, 10:36 PM #2
    jggtz
    jggtz is offline
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: recordset.find

    FIND method only allow one criteria

    You could execute a SELECT_FROM_WHERE query with 2 criterias over the connection
    or
    FILTER the recordset with the 2 criterias
    or
    FILTER on one criteria and use FIND with the other criteria
    Last edited by jggtz; May 12th, 2013 at 10:43 PM.
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
    Reply With Quote Reply With Quote
  3. May 13th, 2013, 02:46 AM #3
    Joacim Andersson
    Joacim Andersson is offline
    I'm about to be a PowerPoster! Joacim Andersson's Avatar
    Join Date
    Jan 1999
    Location
    Sweden
    Posts
    14,649

    Re: recordset.find

    Moved to the Database Development forum.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width