User entering all three fields in a text box so the problem is to send a query to get all address:
You may create one field ad4 in the Db. Just add all add1+ad2+ad3 and everything in one field.(not a good solution)
or Just add a single field ad1 add all the field
Else create the user interface...
For exact word searching use like: say user enter address to text1. I belive even if there is a comma it will work
Select from Table where address1 like '" & text1.text &"'
I THING YOU HAVE TO DEVELOP A SOFTWARE WITH VB OR C++. SO USER CAN ACCESS THROUGH THE SOFTWARE. YOU DON'T NEDD MS ACCESS INSTALLED IN THE USER COMPUTER.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.