Thread: Finding records

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    3
    Rep Power
    0

    Finding records


    Hi! i am required to make a microsoft access query or visual basic program to find records from the tables. The program i am currently using is microsoft access.

    For example if i want to find a record call 'snake' from a table and i do not know the spelling so, i type 's' or 'sn' in a form, and the the program will search records from my table for any relevant records with the character i type into the form. Then show the results of the records.

    Anybody can kindly help me or provide me with the sample program?
  2. #2
  3. No Profile Picture
    Average Intelligence
    Devshed Novice (500 - 999 posts)

    Join Date
    Apr 2003
    Location
    Ohio/Chicago
    Posts
    678
    Rep Power
    12
    huh? Do you want the query or the program?
    Code:
    SELECT *
    FROM table
    WHERE columnname LIKE '%sna%'
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    3
    Rep Power
    0
    a program which can match the words input by the user

IMN logo majestic logo threadwatch logo seochat tools logo