Need Report with PDF Link

[vbbbmom]

OK. I am not sure if I can explain exactly what I want but here it goes.

We have a contract (Access Report) and this contract consists of many parts, the art I need help with is the product specifications section. We receive product quotes from several different vendors, via the vendors specific software. To get the quote we enter the product specifications into the vendor specific software and they generate a quote for the product. We are trying to simplify the creation of the contract and so rather then hand entering in the product specifications into the DB (since we have already entered this info once into the vendor software) I think it would be more beneficial to be able to link the PDF Copy of the specifications directly into the contract. This will be a different document for each contract. when it is time to print the contract I want the associate to be able to save the PDF Quote to a specific drive on the network and they will name it the job number since this is a unique ID. This Drive\Folder\Job number will be linked to the contract and when they print the contract the PDF Quote will appear in the Product specifications page within the contract (Maybe as a sub report?).

I first need to know if this is possible and how do I do it? The PDF's are multi-page docs most of the time, not sure if this matters.

I am familiar with linking images and have tried to do something similar within the contract but have not been able to get this to work with pdf's.

Any help would be greatly appreciated.

Thank you!

 

[Pat Hartman]

You need to be using A2007 or A2010 to have "live" reports. Store the path to the pdf in your table and show it on the report. In the click event of the control on the report, use the FollowHyperlink Method to open the document.

 

[vbbbmom]

Thank you for the reply Pat. I am using A2010. I will try it out and let you know if I have any issues.

Thanks!

Shellyn

 

[vbbbmom]

OK Pat, I followed your instructions and I may not have explained what I need very well so I will try again. I created a mock DB with a phony contract and data. although I am using A2010 so I will not attach it. I am uploading 2 PDFs of the report with an example of what is does when it prints and what I would like for it to do.

When the report prints out is prints out the link to the document and I actually would like the document to appear inserted into that portion of the contract not the link. Kind of like we can do with images and the image frame, you save the link in a file path field and the image frame is directed to that link and the image actually appears in the document not the link. I have tried working with the OLE Object but have not been able to get that to work.

It may not be possible but it would prevent a lot of duplicating work on our side if I could figure out how to get this to work.

Thanks again for your earlier reply.

Shellyn

 

[Pat Hartman]

I don't know the answer. Hopefully someone else does.

 

[spikepl]

Some discussion of alternative solutions by A. Kallal here: http://www.tech-archive.net/Archive/Access/microsoft.public.access.reports/2007-09/msg00767.html

 

[vbbbmom]

Thank you Pat and Spikepl. I appreciate your time.