Attaching Documents

[Guest]

Is there any way to attach documents to an Access form, report, or table? It
is all handled on-line, so when someone opens the form to see the latest they
need to be able to see the supporting documentation too.

Thanks

David

 

[Arvin Meyer [MVP]]

You can use an OLE field to embed the document in an Access form (or
report). Thay generally leads to excessive bloat and an increased risk of
corruption. The best way is to store a link to the document and use a button
or hyperlink to fetch it on demand. An example is my DocMgr sample
database.:

http://www.datastrat.com/Download/DocMgr_2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

THat looks great and will probably used in future updates. But, immediately,
I want a box on my form that will contain a link (as I have read that this is
a much better way than actually carrying around the entire file) to a file
that is needed. I found that I can create a "Hyperlink" field to hold the
link. My next question, is there a way to make a small button that "Browses"
to find the file, then when the file is found and clicked on it leaves that
target in the Hyperlink field?

Thanks

David

 

[Arvin Meyer [MVP]]

Check out the code at:

http://www.mvps.org/access/api/api0001.htm

and use it to browse for a file. You can use it the same way that the DocMgr
code looks for folders. Saving the full path will allow you to use a
hyperlink. If you noticed, the "GetFile" label in DocMgr, turns any path
into a hyperlink address and will allow you to use multiple hyperlink
protocols.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access