full-text search form / subform

[Bernie]

I am writing a full-text search module for the main form and n subforms. Has
anyone done this before? I really dislike the rather simple search routines
in access and prefer full-text search across main / subform/s.

Any comments most appreciated.

 

[Minton M]

I am writing a full-text search module for the main form and n subforms. Has
anyone done this before? I really dislike the rather simple search routines
in access and prefer full-text search across main / subform/s.

Any comments most appreciated.

I have, but only using a stored procedure on a SQL Server backend, so
the performance was good. The new filtering/searching in Access 2007
seems to be much improved by the way.

 

[Bernie]

Dear Minton

Thank you for your reply. I know what you mean as my programmer back in the
mid 90s did exactly the same with excellent results. My environment now is:

- access 2003
- jet database

I've got a full-text search for the main form and the subform using
wildcards, string > operators etc. that works fine but the problem comes with
the subforms and linked tables and adds enormous complexity and code.

1. table customers
2. table orders
3. table invoices

To code all this is a daunting task (inner joint, outer joint) etc. so I
thought perhaps there is a routine readily available. Linking all these
tables and then creating the search sql string for access just to display the
desired results is a hack of a thing and I'm not too gifted with coding.

Last night I looked into creating the sql search string for data retrieval
from a query built on the various links. Would this be the right way forward
or is there an easier way of doing it?

Any comments most welcome.