Howdy, Stranger!

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

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

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.