find method for database search - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

find method for database search

friends, i am making a package in which i want to search in a database.
on my form i have a find button.
i want to use find method of vb.
like
Adodc1.Recordset.Find "Addcity like 'New Delhi'
it works but i want to accept value from user
thru

dim getdata as string
getdata=inputbox("Enter city","search",0)
Adodc1.Recordset.Find "Addcity like 'New Delhi'"

i recieve value in getdata variable.
but i am unable to search value stored in getdata?
how to go abt it?

plz help

micks

Comments

  • zaib_awanzaib_awan Posts: 9Member
    : friends, i am making a package in which i want to search in a database.
    : on my form i have a find button.
    : i want to use find method of vb.
    : like
    : Adodc1.Recordset.Find "Addcity like 'New Delhi'
    : it works but i want to accept value from user
    : thru
    :
    : dim getdata as string
    : getdata=inputbox("Enter city","search",0)
    : Adodc1.Recordset.Find "Addcity like 'New Delhi'"
    :
    : i recieve value in getdata variable.
    : but i am unable to search value stored in getdata?
    : how to go abt it?
    :
    : plz help
    :
    : micks
    :
    :



    Use this
    Adodc1.Recordset.requery
    Adodc1.Recordset.Find "Addcity like '" & trim(getdata) & "'"


  • micks_guptamicks_gupta Posts: 8Member
    : : friends, i am making a package in which i want to search in a database.
    : : on my form i have a find button.
    : : i want to use find method of vb.
    : : like
    : : Adodc1.Recordset.Find "Addcity like 'New Delhi'
    : : it works but i want to accept value from user
    : : thru
    : :
    : : dim getdata as string
    : : getdata=inputbox("Enter city","search",0)
    : : Adodc1.Recordset.Find "Addcity like 'New Delhi'"
    : :
    : : i recieve value in getdata variable.
    : : but i am unable to search value stored in getdata?
    : : how to go abt it?
    : :
    : : plz help
    : :
    : : micks
    : :
    : :
    :
    :
    :
    : Use this
    : Adodc1.Recordset.requery
    : Adodc1.Recordset.Find "Addcity like '" & trim(getdata) & "'"
    :
    : thnx it worked
    :

Sign In or Register to comment.