Linking files to an Access form.

[klufkee]

Hi all,

I have a form that pulls up records for different companies. Each of
these records has a file that relates to it. (A scanned document in the
form of a pdf, tif, bmp, jpg, doc, or rtf.) One of the fields on the
form is called 'Attachment_ID' and the value of that field is a string
of numbers. (e.g. 1234567890) That string of numbers matches the file
name itself. But the string of numbers does not have the file ext. on
it. So on record x the 'Attachment_ID' field shows '1234567890' and in
the file directory I have there is a file named '1234567890.rtf' What I
need to do is turn that field into a hyperlink and have it open the
file when clicked on. I have tried making it a hyperlink in the
properties of the field but nothing is happening when it gets clicked
on. I'm not sure what I'm doing worng here but maybe someone else has
gone through this and would be willing to share any solutions they
found.

Thanks,
Bill

 

[Guest]

For the hyperlink field to work, it needs to be a fully qualified path and
file name. You'll need to store the path to the file and its extension.

Barry