Fromat seach text for Full text Search

[stephenk1973]

I have a form whose record source is based on the following query.....

SELECT *
FROM Archive WHERE CONTAINS (*, '"Winston"')

The text, in this case 'Winston' come from a text field in the search form.

How do i deal with increased complexity in the search criteria? Has anyone an example vb function for formating the text that is sent to the query taking into account possiblity of 'and's, 'or's brackets etc.

All suggestions appreiciated.

Thanks

Stephen

 

[Darrylles]

Hi Stephen,

Don't try to allow the user to format the options in a single textbox - string manipulation is massively complex to 'parse' (or evaluate).

Give the user options of numerous textboxes (or predefined valuess in combos).

Each textbox / combo should be logically associated with a 'field' in your table.

When the user clicks 'GO' - you can then assess which textboxes have values, and build your SQL string according to which textboxes / combos have values.

Get it?

ATB

Darrylle





Never argue with an idiot, he'll bring you down to his level - then beat you with experience.