Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005
    Posts
    61

    Question Unanswered: Urgent Help With Find Method in VB6

    Hi All
    i have a problem and i need to slove it. ??????
    in my project i use the adodc thing
    and i had these variables
    i wrote this code:

    Dim R2 As String
    Dim n2 As String
    Dim y2 As String

    R2 = "RegStName = " & "'" & Text7.Text & "'"
    n2 = "RegSubjName = " & "'" & DataCombo1.Text & "'"
    y2 = "SemsYr = " & "'" & Text59.Text & "'"
    If Adodc6.Recordset.BOF = True And Adodc6.Recordset.EOF = True Then
    ------
    Else
    ' the problem is here
    Adodc6.Recordset.MoveFirst
    Adodc6.Recordset.Find (y2), 0, adSearchForward
    Adodc6.Recordset.Find (n2), 0, adSearchForward
    Adodc6.Recordset.Find (R2), 0, adSearchForward

    'this work for some condetions but i want to find the 3 variables togather

    i tried to write this
    Adodc6.Recordset.Find (y2) (n2) (R2), 0, adSearchForward
    but it wronge
    is there a way to make this find for the 3 variable to gather
    plz i need help
    and i want it to the ADODC
    i know how to make the the connection and use the select stament but i need that one
    plz i need help
    Sami Al Damiri ...

  2. #2
    Join Date
    Jun 2006
    Location
    Colton, CA
    Posts
    26
    TRY

    Code:
    Adodc6.Recordset.Find (y2) & (n2) & (R2), 0, adSearchForward
    Geek it till it mHz

  3. #3
    Join Date
    Jun 2005
    Posts
    61
    ty but it doesnt work
    dont u have another way
    Sami Al Damiri ...

Posting Permissions

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