global search

  • Thread starter Thread starter Christopher Glaeser
  • Start date Start date
C

Christopher Glaeser

Commence is a PIM that I use that supports a global search feature. Given a
search string, it will search all tables (e.g. contacts, workorders, etc)
and generate a list of hits. If you double click on a hit, it will open the
form/record associated with that hit. I'd like to duplicate that feature in
Access. I did not find any related articles in KB. Suggestions or
porinters on how to approach this problem will be greatly appreciated.

Best,
Christopher
 
Hi, Christopher.

I'm about to implement the same kind of thing. I haven't done it yet, so I
can't give you the benefit of real world experience, but my plan was to start
with an unbound form in which to enter criteria, and add a command button
that would open a form based on a multi-table query that has the criteria
"Like " & Forms!YourUnboundForm!YourCriteriaField & "*" placed in all the
fields you'd like to search, in different rows. This way the query executes
the query as a logical "OR".

Good luck; hope this gives you a start off point.

Sprinks
 
Back
Top