How to open up and search through a Word document using Access VBA?

[shawnntjr]

HI all, I'm in a dire need of help right now. I am not sure if it is even possible, but I need to create an application whereby the user enters a search keyword in an Access form, and the form will locate the Word document, which is stored in Sharepoint. The Word document will then open and be immediately directed to the page whereby the search term was found.

E.g. User searches for "ABC phone number" and the form will open ABC's Word document and immediately be at the phone number's page.

How do I go about doing this? Or at the very least, just open up the correct document from Sharepoint?

[twinnyfo]

shawnntjr,

What have you tried so far? This is most likely possible. However, a lot of this will depend upon your expertise.

MS Word can be completely automated using VBA (via Access or any other MS Office application), but what you are asking to do can be very complex.

You are asking the DB (or user) to know while file to open, which begs the question, if the user knows which file to open, why could they not simply open the file and do a manual find of the text item?

Granted, I understand the desire for full automation--and I am on your side there--but sometimes the effort required to automate something so simple is not worth the benefit it provides.

Just a few thoughts. We are standing by to assist further if you show us how you have tried to tackle this problem yourself, as we typically don't offer the entire solution, but assist in troubleshooting non-functioning code.