Cannot Open Attachments In Pdf Created From Access (1 Viewer)

F

frmla77

New member

Local time

Today, 17:17

Joined

Apr 8, 2015

Messages

9

• Nov 4, 2015

• #1

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

Eledittingent Beliped

Local time

Tomorrow, 00:17

Joined

Nov 3, 2010

Messages

6,142

• Nov 4, 2015

• #2

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?

 

A

AccessBlaster

Registered User.

Local time

Today, 15:17

Joined

May 22, 2010

Messages

5,951

• Nov 4, 2015

• #3

frmla77 said:

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

Click to expand...

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

Code:Copy to clipboard

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

 

gemma-the-husky

Super Moderator

Staff member

Local time

Today, 23:17

Joined

Sep 12, 2006

Messages

15,656

• Nov 5, 2015

• #4

can you in fact have a pdf that contains attachments?

I don't know?

 

S

sneuberg

AWF VIP

Local time

Today, 15:17

Joined

Oct 17, 2014

Messages

3,506

• Nov 5, 2015

• #5

gemma-the-husky said:

can you in fact have a pdf that contains attachments?

Click to expand...

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.

 

Last edited: Nov 5, 2015

F

frmla77

New member

Local time

Today, 17:17

Joined

Apr 8, 2015

Messages

9

• Nov 5, 2015

• #6

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

 

Attachments

• 
  pdfWAttachments.png

  23.6 KB · Views: 98

F

frmla77

New member

Local time

Today, 17:17

Joined

Apr 8, 2015

Messages

9

• Nov 5, 2015

• #7

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

 

Attachments

• 
  pdfWAttachmentsNotEmbedded.png

  42 KB · Views: 97

F

frmla77

New member

Local time

Today, 17:17

Joined

Apr 8, 2015

Messages

9

• Nov 5, 2015

• #8

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

 

Attachments

• 
  rtfWNoAttachments.png

  11.7 KB · Views: 92

A

AccessBlaster

Registered User.

Local time

Today, 15:17

Joined

May 22, 2010

Messages

5,951

• Nov 5, 2015

• #9

frmla77 said:

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

Click to expand...

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.

 

F

frmla77

New member

Local time

Today, 17:17

Joined

Apr 8, 2015

Messages

9

• Nov 5, 2015

• #10

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.