September 4th, 2003, 04:32 AM
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?
September 4th, 2003, 11:27 PM
huh? Do you want the query or the program?
WHERE columnname LIKE '%sna%'
September 7th, 2003, 01:49 AM
a program which can match the words input by the user