Help setting up a search button to search access db

[tmidgett]

Hi I am new to vb6 I used the wizard to set up a form in vb6 to access a access 2000 database. It works great I want to add a button to search the LastName field in my table. I have added the label,text box and command button to the form. I double clicked the command button to get to the code screen. I am not sure what code to add to this button to get it to use the textbox to search the lastname field?
Thank Tim

 

[zemp]

Searching can get involved depending on how far you want to go. The main part will be to build the SQL statement. In its simplest form it should end up being similar to,

"Select * From Table1 Where Lastname =' " & Text1.text & "'"

I would search some of the code respsitory sites for examples. Try

http://www.planetsourcecode.com,

http://www.a1vbcode.com

or

http://www.freevbcode.com.

You can find more links at these sites.

Take Care,

zemp

"Show me someone with both feet on the ground and I will show you someone who can't put their pants on."