I am trying to make a program using Visual Basic 2008 express edition, that would allow the user to enter in a search word and the program would then return any matching results from an Access database.
I can't figure out how to make it so that the query searches based on what the user has typed in say.. TextBox1. I have tried several variations of code.
For example:
SELECT...
FROM...
WHERE column1 = TextBox1.Text
and
WHERE column1 = "TextBox1.Text"
and
WHERE column1 = '& TextBox1.Text &'
and even
WHERE column1 = '" & TextBox1.Text & "'"
Depending on how I try to write it, it will either come up blank, or will tell me "No value given for one or more required parameters."
Is there some way I can write this differently so it does the search using whatever is in TextBox1? If not, what else can I do that would give me the same results?
2007-12-30
14:59:03
·
3 answers
·
asked by
DuxBelorum
1
in
Programming & Design