helpdesk98 Posted April 5, 2012 Posted April 5, 2012 I am working on a small vb project I have a small one table MS Access database connected to my vb project. Everything load properly and responds the way I want it to. Now I want to add querys based on variables. In the screen shot below I have a input box for the drawing id and a submit button when I click the submit button I want it to run this sql query:select drawingIDfrom tblshapeswhere drawingID = [varable from the input box]any ideas I tried to use the query builder, but I can not insert variables from my inputbox
gunsmokingman Posted April 5, 2012 Posted April 5, 2012 Now this is just a guess If Not THE_NAME_OF_THE_TEXTBOX.TEXT = "" Then ' Query Code Here ' THE_NAME_OF_THE_TEXTBOX.TEXT End If
helpdesk98 Posted April 8, 2012 Author Posted April 8, 2012 I found a way to do it with the old query builder from MS Access. The way I was trying to do it was way to complex for me lol. Thanks for the help
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now