Cannot Open Attachments In Pdf Created From Access

[frmla77]

Using "DoCmd.OutputTo acOutputReport, "rptXXXXXXX", acFormatPDF, myFileName, -1" to generate a pdf version of a report. The report can consist of attachments of pdf, excel, word, etc. When the pdf is generated I am not able to open the attachments that are in the pdf.

Was curious if this is a known problem that I am not able to locate, if it is possible to open an attachment in a pdf file created by MS Access or other options. Would like to continue to use attachments, but if not feasible, can use hyperlinks.

Thanks

Michael

 

[spikepl]

This is really a poor and ambiguous formulation. Say what you do and what happens in response to that, never use the totally informationless "I cannot", because that contains no useful information for you helpers.

What office version do you have what pdf reader do you have what windows do you have?

 

[AccessBlaster]

Using "DoCmd.OutputTo acOutputReport, "rptXXXXXXX", acFormatPDF, myFileName, -1"

The basic output code is below, pay attention to the quotes and notice the word true not -1 substitute the rtf for pdf. https://msdn.microsoft.com/en-us/library/office/ff192065.aspx

DoCmd.OutputTo acOutputTable, "Employees", _ 
 acFormatRTF, "Employee.rtf", True

 

[gemma-the-husky]

can you in fact have a pdf that contains attachments?

I don't know?

 

[sneuberg]

can you in fact have a pdf that contains attachments?

It appears you can http://blog.systoolsgroup.com/open-view-attachments-in-pdf.html

I didn't know that you could attach an Excel spreadsheet or other such things to a Access report.

 

[frmla77]

Sorry spikepl, I thought I did not only just say that I can't do something and had some information in my original post. But here is some specifics.

MS Access ver 2013
Windows ver Win 7
Adobe Reader ver XI


gemma - I have attached a portion of my pdf with the attachments indicated, just when you click on them nothing happens, does not kick off the file.

accessblaster and sneuberg - I will look at the links you posted. Maybe rtf will work, will have to see if any formatting issues, etc.


***

Again, within the Ms Access reports, the attachments are executable, however transition to pdf they are no longer executable. I think it is because the files are not transferred into the pdf. Not real sure. May not be an MS Access issue, just an Adobe Reader limitation.

So, I thought I would see if anyone has encountered this before or knows about it.

Thanks,

Michael

 

[frmla77]

Ok, looked into the document from sneuberg, the files do not seem to be embedded into the pdf. Maybe when MS Access converts to pdf, it is not embedding the files into the pdf, just images.

Attached is an attachment that shows the pdf with the manage attachments window open and nothing there. Also shows the section with the attachments or attachment images.

Figured I'd give some more info on what I looked at, will look into the rtf portion.

Thanks again

 

[frmla77]

Tried the rtf format. I lost my conditional formatting on the reports, plus the attachments are not displayed on the report. Which part of it makes since, I think, since it should really just be a text document, no sure.

Attached is an image of rtf with the field and not attachments.

So, I guess the question is, can MS Access embed attachments into a pdf document. Or is the only thing that can be done is provide executable url's to a file.

Thanks

 

[AccessBlaster]

Tried the rtf format. I lost my conditional formatting on the reports, plus the attachments are not displayed on the report. Which part of it makes since, I think, since it should really just be a text document, no sure.

Attached is an image of rtf with the field and not attachments.

So, I guess the question is, can MS Access embed attachments into a pdf document. Or is the only thing that can be done is provide executable url's to a file.

Thanks

I wasn't suggesting you use rtf, rather use the correct output method format. Reports are generally not interactive, but you may be able to embed a hyperlink within a PDF.

 

[frmla77]

My bad, accessblaster. Made an assumption there.

I have seen about embedding a url, just need to figure out the best way to capture the url of the file, to prevent typing issues.