Creating query forms

B

bbrown

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.
 
S

S.Y.M. Wong-A-Ton

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
 
Top