I want to look up a record from a database i am able to see all record but i want to use a text box to find an specific record Somebody help me
I need Help, database
Hot Topic
- converting addressof
- I have exactly the same problem
- How to access the clicked item?
- Online help doesn't prompt for Proxy Authentication
- How do I... ?
- Custom DataGridView Column Based on Custom Control
- Array of Buttons
- Playing audio.
- vb.net 2003 simple access mdb example? Anywhere?
- adding functions to a Botton in my Form
Visual Basic
- Handling Repeated Arrow Keys
- event of hovering cursor over PictureBox.
- Browser question/code.
- Simple Problem: Allow Only Number Input In Text Box
- Object reference not set to an instance of an object.
- txt files
- SQL Stored Procedure with VB.NET code, no dataview
- How to delete the Vbnewline
- problem of controls array in Visual Basic 2005
- SQL Express & VB Express Debugging Strategies
I need Help, database
jwellsntr
in addition to the answer DMan1 supplied, I would also suggest trying to understand more about SQL/MS Access queries (SELECT commands) as if you have more understanding, you can implement better solutions.
Currently as suggested by DMan1, it will only specifically find that record if the field matches the textbox text EXACTLY.
If you wanted to do a "similar" match then you would normally do this:
"SELECT * FROM theTable WHERE theField LIKE '%" & Me.theTextBox.Text & "%'"
would bring back the similar matches to the value given from the textbox
BradV2
It would help to be more specific and to even post the code you are having problems with...to select the record from the db use a command object and sql....
"Select * From TheTable Where TheField =" & Textbox1.Text
Now that is the simplest means to get what your after...but the best practice is to use a command parameter so that you prevent injection attacks on your Db