How do i create attachments that point to specific documents

[James Hisey II]

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.!!!

 

[Klatuu]

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)