keyword search

  • Thread starter Thread starter Chrisx
  • Start date Start date
C

Chrisx

My boss would like my form to have search capability
where she could select a field that she wants to search,
enter a keyword and get the record(s) that meet the
criteria.
We have a database that keeps track of courses
offered. There is the course name as well as a
description of the course.

As an example, she wants to be able to select course
name or description and search for any occurrence of the
word "C++". If course name was selected it would return
courses where C ++ was in the course name, like "Intro to
C++", "Advanced C++ Topics", etc.
If description was chosen, it would return courses
that had descriptions like "This class is a pre-requisite
for C++", "Builds on fundamentals from Intro to C++", etc.

Would it be like 2 combo boxes, 1 to select the field
to check (course name, description) and another to enter
the string to search for? Can this be done?

If I didn't explain this clear enough, please let me
know. Thanks for the help.
 
I would put a 'search' button next to each of the fields that would be
searchable. When clicked, I would have a msg box come up and ask for the
string to search for. I would then apply a filter to the form based on that
string.

I'd also have a button on my form to 'remove filter' or 'show all'.
 
Chrisx said:
My boss would like my form to have search capability
where she could select a field that she wants to search,
enter a keyword and get the record(s) that meet the
criteria.
We have a database that keeps track of courses
offered. There is the course name as well as a
description of the course.

As an example, she wants to be able to select course
name or description and search for any occurrence of the
word "C++". If course name was selected it would return
courses where C ++ was in the course name, like "Intro to
C++", "Advanced C++ Topics", etc.
If description was chosen, it would return courses
that had descriptions like "This class is a pre-requisite
for C++", "Builds on fundamentals from Intro to C++", etc.

Would it be like 2 combo boxes, 1 to select the field
to check (course name, description) and another to enter
the string to search for? Can this be done?

If I didn't explain this clear enough, please let me
know. Thanks for the help.
Click to expand...
You should be able to do this by using Edit/Find in the menu.
Use an * before or after your criteria.

If I'm searching a last name field I can enter "rob*", This will return
all last names
that start with rob.
Check the options in the find dialog box You will want to set "Only the
current field"
and may need to set "Any part of".

Ron
 
Back
Top