checking the database

[Okere]

i have created a customer table containing name and ID in datsbase and i want if i type in the customers ID number lets say in a textbox, (1)it should check the database to see if the ID exist and (2)then call up the corresponding name with that ID and display it in a label button>>>please reply my threads...its urgentchecking h

[Reverend Jim]

We will not do you work for you. We will help with specific problems if you

1. provide specific information
2. show us that you have put in some effort to solve it yourself

Keep in mind that while it may be urgent to you, it is not urgent to anyone else.

[Joe-Guru]

Hello,
Kindly submit your code so that we can see where you got stuck
Example:

private sub Command1_Click()
dim rs as Object,DB as object
    SET rs=CreateObject("ADODB.Recordset")
    set DB=CreateObject("ADODB.Connection")
    DB.OPEN "Connection_string_to_data_base{replace with}"
    sql="SELECT *FROM `table_name` WHERE Id_column=" & val(text1.text)
   set rs=db.execute(sql)
    if rs.bof and rs.eof then
        msgbox "your record search criteria falied/record with provided id not found"
        DB.close
        rs.close
        exit sub
    end if
    label1.caption=rs.fields("culumn_to_get_name").value
    msgbox "We found you record....Thank you"
end sub