Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TheKidLarose

    Creating a stand alone application in Access

    Can you create an exe file using Visual Basic 6.0 and use the forms or tables built with Access 2000. tks Denis
  2. TheKidLarose

    Creating a stand alone application in Access

    Does anyone know if you can create a stand alone application with mdb files created using Access? tks Denis Larose
  3. TheKidLarose

    Find a record using code

    Thanks Bob I got it to work using your info. I really appreciate it Denis
  4. TheKidLarose

    Find a record using code

    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...
  5. TheKidLarose

    Searching for records that match user input

    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...
  6. TheKidLarose

    Searching for records that match user input

    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...
  7. TheKidLarose

    Searching for records that match user input

    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...

Part and Inventory Search

Back
Top