attach PDF files

[Hong]

I have lots of different binders to file different documents.
Now I want to make it more organize.
I scaned the document into PDF start from this month,
I am going to create different tables for different type of documents.
for example a table PO for purchase order. and attached the PDF (with
manager sign off signature).
Is that possible I can attach the PDF in the table and showing on the report?
Any suggestion is appreciate.

 

[kingston via AccessMonster.com]

I suggest that you just have one table and add a field that classifies the
document. This will allow for easier searching, filtering, etc. In the
table, just reference the location of the PDF (e.g. \\Server\PDFs\File123.pdf)
; do not embed the file as this will make your file grow tremendously in size.
In your form, add the Adobe PDF Reader ActiveX control and change the .src
property to the file location string. This will only work for one PDF at a
time, but it is a quick, light-weight, and flexible solution. I'm not sure
what you want to do with the PDF in the report but the ActiveX control will
work just like Adobe's PDF reader with the ability to search, print, etc.
HTH.