Searching Hyperlinks

[wvanpup]

I am trying to create a database (Access 2007) that includes hyperlinks to letters sent to clients. Eventually there will be hundreds of letters. Suppose I am looking for letters related to Product XYZ. Is there a way to search the letters through the database for those that refer to Product XYZ in the body of the letter (i.e., the term Product XYZ will not appear in any field in a record, and will only appear in the body of the hyperlinked letter)?

TIA for any assistance that can be provided.

 

[vbaInet]

If the letter is a .doc format (i.e. MS Word) then you want to ask this question in a Word forum. They will be able to give you better advice.

Or if you know how to script, you can use something like VBScript to search for text within the file or Perl (for example). This isn't related a VBA Access question.

 

[wvanpup]

Thanks for the information. I will quibble about one thing; I think the question is an Access question since I wanted to know if I could do the search within Access. I think I can do the search outside Access, but that is not my first choice.

 

[vbaInet]

You are searching within a file, it's not Access VBA dependent. You can run VBScript code from within VBA so perhaps that's what you should be looking into. Scripting languages (such as VBScript) are for file searching and manipulation, VBA doesn't match up in that respect.