How do i create attachments that point to specific documents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James Hisey II - 14 Jul 2005 19:40 GMT

I'm trying to create a knowledge base in access and want to create a field
that will accept attachments or open to a specific word document or e-mail.
Ideally the user would be able to click on the attachment and open the
supporting e-mail etc.

any ideas are welcome indeed.!!!

Signature

Jim

Reply to this Message

Klatuu - 14 Jul 2005 20:48 GMT

One way would be to add two fields to your table. One would be a Hyperlink
data type containing the path and file name of the document and the other
would be a Text field containg the type of document. For example, for a Word
document, you could store WINWORD.EXE in the document type. Then when you
want the document to open, use the Shell function to open it.

strdoc = "winword.exe " & chr(34) & "C:\Documents and Settings\hargida\My
Documents\Admin Info\busmgmt dates.doc" & chr(34)
Shell(strdoc)

> I'm trying to create a knowledge base in access and want to create a field
> that will accept attachments or open to a specific word document or e-mail.
[quoted text clipped - 3 lines]
> any ideas are welcome indeed.!!!
>

Reply to this Message