The following fails because of the question mark. A question mark is a wildcard along with a few other characters.
query = “Is this a nice day? Fred”
Set searchDb = DbSearch.FTSearch( query, maxDocs )
How can I include a question mark in my query and return the results I’m after?
Subject: have you tried putting it in quotes ?
instead of:
query = “Is this a nice day? Fred”
Set searchDb = DbSearch.FTSearch( query, maxDocs )
try:
query = |“Is this a nice day? Fred”|
Set searchDb = DbSearch.FTSearch( query, maxDocs )
or
query = “‘Is this a nice day? Fred’”
Set searchDb = DbSearch.FTSearch( query, maxDocs )
Subject: Nope, no go, doesn’t work in the view search bar either