Re: best way to search for multiple words through a query

vonclausowitz@xxxxxxxxx wrote:

I have more than one field.
I want to search in text and memo fields of a table.
If a field is a textfield than within that textfield the words should
be within n word.
In the memofield the same.

Can you give me an example for RegExp how to do this?

You need to learn how to use GoogleGroups.
Goto http://groups.google.com/advanced_search?hl=en and enter
*Access*
in the "return from group" textbox. And of course, enter some search words...in your case RegExp.



Marco


pietlinden@xxxxxxxxxxx schreef:


RegExp. Look up Regular Expressions. That would probably be easier,
once you get the hang of it. And *much* less code.


.

Relevant Pages

  • Re: Any alternative to memo fields?
    ... another solution is to use a seperate table for the textfield where you use ... > I have an access database with many tables. ... > alternative to Memo fields is sought because it is said that Memo fields ...
    (microsoft.public.vb.database.ado)
  • Re: Any alternative to memo fields?
    ... another solution is to use a seperate table for the textfield where you use ... > I have an access database with many tables. ... > alternative to Memo fields is sought because it is said that Memo fields ...
    (microsoft.public.data.ado)
  • Re: Any alternative to memo fields?
    ... another solution is to use a seperate table for the textfield where you use ... > I have an access database with many tables. ... > alternative to Memo fields is sought because it is said that Memo fields ...
    (microsoft.public.data.oledb)
  • Re: best way to search for multiple words through a query
    ... I want to search in text and memo fields of a table. ... If a field is a textfield than within that textfield the words should ... pietlinden@xxxxxxxxxxx schreef: ... once you get the hang of it. ...
    (comp.databases.ms-access)
  • Re: Form Field Validation Question
    ... While in the textfield, it is not a number, it is a string. ... For more complex checks a regexp would be more helpful. ... Also welcome to move the check into the head section: ...
    (comp.lang.javascript)