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
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now