Creating query forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bbrown - 08 Dec 2005 13:25 GMT

Hi there, I have created a form connected to an sql database and I am trying
to add a query field that will keyword search a description field that can
include many paragraphs of information. I am unsure how to do this, searches
seem to only return exact text queries.

Signature

bbrown
software support

Reply to this Message

S.Y.M. Wong-A-Ton - 09 Dec 2005 19:12 GMT

Hi,

Did you already take a look at this? It applies to Access, but could provide
the answer you're looking for:
http://support.microsoft.com/?scid=kb;en-us;826992&spid=2515&sid=229

If that's not what you're looking for, I'd suggest writing a webservice to
retrieve your data and query the db through the webservice using the CONTAINS
or FREETEXT predicate (see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_
15_64dv.asp).

Hope this helps.

Regards,
S.Y.M. Wong-A-Ton

> Hi there, I have created a form connected to an sql database and I am trying
> to add a query field that will keyword search a description field that can
> include many paragraphs of information. I am unsure how to do this, searches
> seem to only return exact text queries.

Reply to this Message