Print linked pdfs within an Access Report

[alpruett]

I have a linked pdf file associated with each record in my database. I would like to create a report that would show the data from the access record, then the pdf linked to that record, then the data for the next record, and so on. Is this even possible?

[ajetrumpet]

of course it's possible. HOW is it linked?? is it an OLE field or a hyperlink field?? If it's a HLINK, then obviously you just include that field in your field list of the report.

[alpruett]

It's via a hyperlink field. When I add the hyperlinked field to my report, it simply creates a report with the hyperlink intact. I want the actual document to be reproduced in the report when I print that report to a pdf. Am I missing something obvious?

[ajetrumpet]

I want the actual document to be reproduced in the report when I print that report to a pdf.

so you want to push a print button and print the actual PDF document?? if that's what you want, why would you print the report too??

It sounds to me like you're confusing the "print to PDF" export option. That does NOT, by default, print anything but the report object in PDF form. Make sense?? So what you can only get with that is what you're seeing on the screen. the rpt with a bunch of underlined blue hyperlinks on it.

what I think you should do is put a button on your report that runs the vba code to print the document behind the hyperlink. It's only a couple of lines, or should be...

Make sense so far??

[alpruett]

The reason for the report too is that the reports are from queries that will pull certain types of files. My supervisor wants to be able to open a report, hit print to pdf, and have only the files that result from a particular query. She would also like the query report to print because it includes some details about each document.

I have not encountered adding a button to run a vba code to print the doc behind the hyperlink, but it sounds like what I need. Can you explain the steps and code to make this happen? Please bear with me as I'm very much a novice. I've become fairly proficient at basic Access, but rarely have ventured into the world of VBA.

[ajetrumpet]

OK, so basically you've answered your own question with this:

My supervisor wants to be able to open a report, hit print to pdf, and have only the files that result from a particular query. She would also like the query report to print because it includes some details about each document.

so you need the rpt for info, and you need the PDF's for the content. if you wanna do it urself, start here: http://www.google.com/search?sclient...7&pf=p&pdl=300

concepts like printing files in folders from vba code are asked by people all over the world. thus, you don't have to think of a specific search phrase in google. almost anything will give an answer that's viable.

as far as the code writing, ur welcome to upload something here and I'll give u a sample of code that u'll need to use for looping data. that's the bulk of the coding for printing files.

[NoellaG]

Hi all,

I didn't try it myself, but if you have a hyperlink, this object has the property "Address".
If you add a bound object frame to your report, and set the OLE class to "Adobe Acrobat 8.0" (or your version) and set the source doc to the hyperlink address, it just might work.

here is a snippet code from the help files with an example how to set the properties of an object frame:

Sub Command1_Click      
OLE1.Class = "Excel.Sheet"    
' Set class name.      
' Specify type of object.     
 OLE1.OLETypeAllowed = acOLELinked      
' Specify source file.      
OLE1.SourceDoc = "C:\Excel\Oletext.xls"      
' Specify data to create link to.      
OLE1.SourceItem = "R1C1:R5C5"      
' Create linked object.      
OLE1.Action = acOLECreateLink      
' Adjust control size.      
OLE1.SizeMode = acOLESizeZoom  
End Sub

Hope you find something, and if so I'm very interested to know. Success

NG