Embed document in Access Form

I have several access databases that open to Forms.  I have word documents for these explaining the procedures.
I would like to embed the procedure document into the DB some how and then add a shortcut or button on the form that would open the procedure word doc.
I don't know how to do this - any ideas???

Thanks
vpopperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
You can do it, ...but it will tax your system severely.
You could use what is called the "OLE Object" datatype
Using this datatype, the document would always be visible, so there would be no need to click a button to open it.

The other option (if you are using the newer versions of Access) is to use the "attachment" datatype.
Then you could simply click the field and have the option to Open the document.

If it were me, I would take the raw text from the word Docs and insert the text into a field in the database.
(you can use special formatting to make the text look nicer , if you like)
...and not "embed" an entire word doc into the form.
Both of the techniques above (OLE Object and the Attachment datatype) will "bloat" the database, and the increase in size will start to slow down your database.

JeffCoachman
0
omgangIT ManagerCommented:
You don't need to embed the document into the database.  You can create a link to the document so that it will open for the user.  Is this a shared application with multiple users?  Can the documents be stored on a network file share that all users will have access to?
OM Gang
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vpopperAuthor Commented:
I accepted this solution - seemed to be the easiest.  I do appreciate all the solutions provided!

Thanks
0
Jeffrey CoachmanMIS LiasonCommented:
There is one other option...
You can have a "Link" to the word document on the form.
Store the full path and file name of the word doc to a field in the table.

Then just use code like this on a button to pen the document:

    Application.FollowHyperlink YourFulNameAndPathField


Or use the "Hyperlink" datatype to be able to click the link directly (to open the file)

Using the Hyperlink datatype would probably be best in your situation.
You can view info on this here:
https://www.webucator.com/blog/2010/07/the-attachment-field-in-access-2010-and-in-access-2007/
;-)

JeffCoachman
0
Nick67Commented:
For a button

   Dim oApp As Object
   Set oApp = CreateObject(Class:="Word.Application")
   oApp.Visible = True
   'Open the Document
    oApp.Documents.Open "TheDriveLetter:\ThePath\theFileName.Extension" ' a proper path to the Word document you want opened.

Pretty straight-forward
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.