helpdesk98 Posted April 5, 2012 Share 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 Link to comment Share on other sites More sharing options...
gunsmokingman Posted April 5, 2012 Share 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 Link to comment Share on other sites More sharing options...
helpdesk98 Posted April 8, 2012 Author Share 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 Link to comment Share on other sites More sharing options...
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