-
Hi
I need to select from a database all the records containing HomePhoneNumber. I want the user to be able to enter the home phone number to search for . Then i need to display it. I need some ideas on how to do this. I've tried lots of things with no success. Any help would be appreciated .
Keeep in mind I am still new to VB.
Thanks
-
I can't put a more complete sample because I don't know what database object you are using. But I hope this idea helps you.
Code:
SELECT * FROM table WHERE HomePhoneNumber = '" & MyPhone & "'"
Good Look!
Ulises
-
I am using a ms Access database. One main problem is How do I show the results in a grid. The SQL search will return several records.Also can any one tell me just how to display the results?
Any help would be appreciated