i have created a customer table containing customer_name and customer_ID in database 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 urgent

Let's see some screenShot

I will get ban today

set up database connecction i guess you can do dat

record here is your recordset name

Private sub search()
call connectionname
set record = new adodb.recordset
record.open "select * from databasetablename where customer_ID ='" text1.text"' and customer_name = '"text2.text"'", activeconectionname, 3, 3

if text1.text = "" & record.customer_id and text2.text = "" & record.customer_name then
label1.caption = "" &record.customer_name
else
msgbox ("no record found", vbcritical")
end if

set record = nothing
close activeconnection
end sub

if you dont get it add me on whatsapp to send the script to you

08032950881

^^^^Na the screenshot be that bah? Oya proxy20, carry on - your screenshot has been supplied with gusto.

dhtml the guy said he has created the database Wats the problem na .

Oh, i see, thread padlocked then!

You don't give a screenshot and you want your problem solved? Spiritually? Or metamorphically?

If I say something someone would start looking for something to say to me, why don't u press print screen, save in paint and save on your desktop and upload here. So they have your problem fixed for you.

^^^By oyinbo magick

Yea and by the way which industry standard applications uses visual basic 6.0 these days?

^^^None that i know/have heard of.

His mates are learning pascal /c# /c++ he's backdating himself with visual basic which even Microsoft has closed and cancelled anything or rather everything to do with, that's why they created vb.net, and even c# which is basically drag and drop and some fewer lines of code.

I even wonder why he doesn't even read in the first place.

@op, Skype was coded in delphi and c++, ios apps are coded in c# or objective C, android apps are coded in java /python / c#,/ java script , windows app in c# or c++ or java or pascal(object pascal) , OS development involves some assembly (nasm, hla) and so many others, you can do system automation and some programming with AutoIT..
Why not do something useful with these languages than work on something that's deprecated?

^^^I am telling you, it is seriously embarrassing and disgraceful for anyone to even be discussing visual basic 6.0 in this age and time.