0

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

3
Contributors
2
Replies
14
Views
2 Years
Discussion Span
Last Post by Joe-Guru
0

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.

0

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
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.