Someone can gave me a code for search as u type searching from may MS ACCESS DATABASE Thx GOD SPEed :P

im using this to txtSearch_change() event


Adodc1.RecordSource = "Select * from myTable where myField like '%" + txtSearch.Text + "%'"
Adodc1.Refresh

if i use that code may vb6 has being crush

im using that code for 2 - 3 years in searching for specific record
idk what is the cause of the crush

ADOdc1.refresh that was the error are you connecting the txtbox in the ADOdc>?

if adodc1.refresh is the cause, it means that your table or field dosen't meet the requirements to post or to refresh the datagrid

can you gave me specific code thx a lot dude :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.