Search results

Mihail: That worked really well, thank you! Now I have to figure out how to display the records on the report that ideally would have the highlighted search words in the reported field. Can I pass the input keywords through a query that would allow for them to be highlighted in the report?

In a new field or in the memofield where the keywords are searching? If the latter, then the code returns all records if a kw is left blank, because I tried it that way.

CJ_London: Do I add this as a module? in the query? I'm confused as to where to enter your code ...

Mihail: My mistake. The code you gave me runs but doesn't account for when a user leaves a keyword space blank.

I am looking for a way to pass keywords entered by form through a query that only returns the memo field where a word that is listed on the form (up to ten words). I would like to have the report have the keyword(s) searched highlighted, but it isn't necessary, especially because all the code I...

pr2-eugin: That code doesn't account for if the user leaves a blank keyword ... if they do it returns all records.

Mihail: That code keeps coming up with the same compile error message.

Thanks for all the great responses. I put in the following code in a module after creating the new field in the query and received an error message - Compile Error: Block If without End If: Public Function ShowThisRecord(strText As String) As String ShowThisRecord = True If...

What do you mean by a "regular module"?

can you take a couple of minutes and explain instr, memofield, and "nz" what they do ... just for future reference. I haven't tried the code yet, but I notice there is double parenthesis )) at the end where does that begin?

Currently, I am trying to search a memo field on a table by having the user enter keywords on a form (up to 10 keywords can be entered). It works when just one keyword is entered, however it doesn't work if more than one is entered. How do I account for more than one keyword being entered to...

What I have is a problem where users will select the department in which is impacted by request so for instance for project #1 marketing, advertising and h.r. can be chosen in a combobox. How can I relate that to contacts associated with each department and have them populated in a form...