Creating search functionality using FORMs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Ive been able to create forms that has a menu which looks up values from one
field and displays the list of possible/closest matching entries.

However, i cant seem to create one which uses multiple attributes:
basically where i would have 4 different fields :
- Day
- Time
- Type
- Year

and a user could input any of the values to search like on amazon book
search facility, you can search by many different values using multple
criteria and find the best possible match.?

Is that possible on Access 2000? any helpful tips would be appreciated
thanks
 
Connie said:
Hi,
Ive been able to create forms that has a menu which looks up values
from one field and displays the list of possible/closest matching
entries.

However, i cant seem to create one which uses multiple attributes:
basically where i would have 4 different fields :
- Day
- Time
- Type
- Year

and a user could input any of the values to search like on amazon book
search facility, you can search by many different values using multple
criteria and find the best possible match.?

Is that possible on Access 2000? any helpful tips would be appreciated
thanks
Click to expand...

Sure. How familiar are you with writing VBA code? Do you want the multiple
criteria to be combined as "And", "Or", or do you want the user to be able to
choose? Should string matches use "Starts with", "Ends with", or "Contains"?

This can range from intermediate to fairly complex coding depending on the
number of fields you want to offer and how much flexibility you want to provide.

Why don't you post what you've tried and we'll go from there. I would suggest
getting it working with just a couple of search boxes first. Expanding beyond
that can often be a matter of copying and tweaking from that point. As you can
imagine, the And/Or complexity gets progressively tougher as you add more search
criteria.
 
Hi Rick, is it possible that i can you to my msn messenger as i would like to
send you a couple of database objects and since i have no VBA training this
sounds like a simple discussion forum feedback isnt really fast enough.
Hope thats okay
Connie
 
Back
Top