Member Avatar for bantex07

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

  • 2 Contributors
  • 6 Replies
  • 117 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by bantex07

Recommended Answers

All 6 Replies

Member Avatar for xtianenikkian

im using this to txtSearch_change() event


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

Member Avatar for bantex07

if i use that code may vb6 has being crush

Edited by bantex07 because: n/a
Member Avatar for xtianenikkian

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

Member Avatar for bantex07

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

Member Avatar for xtianenikkian

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

Member Avatar for bantex07

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.