Display pdf attachment in report

[BrianPeerless]

I have a table that contains data pertinent to parts which are manufactured. For each record I have a part number, revision, manufacturer etc. I also have an attachment dataset which contains a single pdf. I would like to generate a report that has one record per page and displays the pdf attachment.



Generating and formatting the report is no problem, but my pdf attachment only shows up as the acrobat icon.

Please help, my vba is pretty weak. If there is a better way of going about printing pdf attachments I am open to suggestions.

Thanks,
Brian

[ajetrumpet]

isn't the PDF viewer active x control in the active x list in 2007?? I believe it is. could you try that, I wonder? Can you put those on reports?? I know for a fact you can embed them into forms....which I would assume would do this exact thing, record by record...??

But then again, displaying an attachment I'm sure is different than displaying a local address of an actual file, which is the way I did it. But if you could even do that, you could always send the PDFs back to a dir instead of housing them in the db, right?

[BrianPeerless]

I would prefer to keep the pdf nested in the DB, rather than just create hyperlinks. The typical users skill level will be low and this seems to me like the most fool-proof way of doing things.

I can embed the active x control but I don't know what to do with it. Please help.

[ajetrumpet]

alright. let me test something really quick with it. I have a little time here....I'll be right back with ya

[ajetrumpet]

check this sample from David out first: http://www.access-programmers.co.uk/...d.php?t=148324

get back to us if it's not what you need.

[BrianPeerless]

I will check it out tonight and let you know how I make out.