I have been working at this for a over a week and I am baffled. I need help. I am new at coding so this maybe very basic for others but certainly complicated for me. I am trying to create code to take the information from a text box on a form entered by a user and locate records that match...
Thanks Leslie and Darrylle
It still doe not work. I am passing on #NAME to the LastName field on my form. Maybe I do not know the proper syntax for using SQL in my VB Code. If you look at my second response all the fields and the information is there. If I was to use the fields in my second...
Hi Darrylle
Thanks for your reply. I must be doing something wrong because when I run the code the string passed on to the variable SqlStr is the entire line "Select * from People Where LastName Like '" & Me!bxSearch & "*'"
The query my from frmSearchGuest is based on is...
I am a newbie at SQL. I created a search form with a text box called bxSearch and 2 fields named LastName and FirstName respectively. These 2 fields contain over a 1000 records of customer names.
Is there code that I can use so that when a user enters a letter such as "S" all the...
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.