How do i create attachments that point to specific documents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.!!!
 
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)
 
Back
Top