I'm still currently trying to figure this one out, I've found ways around this, by actually making a seperate form, that has a place to type in everything, so each individual txtbox has its one value.
Unfortunately this method doesn't fit my design, so I'm still searching for a way to fix this problem.
User Profile
Collapse
-
Ah, thank you and sorry I posted in the wrong area. Didn't realize, appreciate the assistance.Leave a comment:
-
I'm not sure what exactly changed besides the parenthesis. It auto adds them to my entry when it reformats my code. I c&ped it into my query and again it still says no results.
I'm using Access database (OLE DB). Forgot to mention that earlier, and obviously its pretty important. Sorry for that.
It seems that this is down to it not seeing the value of state. "state" being a variable, is it the syntax...Leave a comment:
-
SQL Query Tool Issue In VB 2005
Hrm, I'm not at all sure my title is clear, but I spent 15 minutes trying to figure out what my real problem was. I'm new here, and brand new to VB and I'm only trying to access a database, search through it, and subsequently display it after the query has finished.
Code:Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click Dim state As String state
No activity results to display
Show More
Leave a comment: