global search

  • Thread starter Christopher Glaeser
  • 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
 
S

Sprinks

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
 
Top