Solved Moved to New Computer, New Version of Access Issue with acFormatPDF (1 Viewer)

[AngelSpeaks]

I did use Access 2013, just installed Access 2019, on a new computer. My old computer has an old version of Adobe Acrobat Pro, while this computer has Adobe Acrobat Reader (which may be the cause of my problem. Client computer has Acrobat Pro also).

This snippet code is not creating any files (it's in a loop to create a pdf file for each row returned in a query:

Dim filenamePDF As String
filenamePDF = directoryName & "\State " & gstrState & " Job " & Job & " Start Date " & sDate & " - CP Upload.pdf"

        With DoCmd
            .SetWarnings False
            .OutputTo acOutputReport, "rptAffidavit", acFormatPDF, filenamePDF
            .SetWarnings True
        End With

I didn't find anything that states a specific version of Acrobat is needed and the VBA References are the same.

Thanks for your help!

 

[Josef P.]

What does the file path look like?
Debug.print filenamePDF
Can you manually create a file under this path?

Why do you need .SetWarnings False?

 

[pbaldy]

And for clarity, Adobe is not required at all for Access to create a PDF with that code.

 

[AngelSpeaks]

Hi Josef, thanks for responding. These files were created on the old computer which has Acrobat Pro. A single page PDF for each 'job' in the query results.

.SetWarnings False? Since a lot of VBA code that I looked at had this, I've been using it. When .SetWarnings True, no changes.

 

[AngelSpeaks]

And for clarity, Adobe is not required at all for Access to create a PDF with that code.

Thanks Paul.

 

[pbaldy]

Thanks Paul.

No problem, but pay attention to what Josef suggested doing. Also make sure you can manually open the report after the code has run and failed to create a file. The "usual suspects" are either a bad path or illegal file name, or a data problem that prevents the report from opening.

 

[arnelgp]

also an alternative to post #2, put the fileNamePDF to msgbox, so you can see and verify if the Path and the Filename is correct.

Dim filenamePDF As String
filenamePDF = directoryName & "\State " & gstrState & " Job " & Job & " Start Date " & sDate & " - CP Upload.pdf"

'for debugging Only
'remove after
Msgbox filenamePDF
'end of code

        With DoCmd
            .SetWarnings False
            .OutputTo acOutputReport, "rptAffidavit", acFormatPDF, filenamePDF
            .SetWarnings True
        End With

 

[AngelSpeaks]

Right now I'm trying to run this on the old computer. Still waiting for the clunker to start up.

 

[AngelSpeaks]

also an alternative to post #2, put the fileNamePDF to msgbox, so you can see and verify if the Path and the Filename is correct.

Dim filenamePDF As String
filenamePDF = directoryName & "\State " & gstrState & " Job " & Job & " Start Date " & sDate & " - CP Upload.pdf"

'for debugging Only
'remove after
Msgbox filenamePDF
'end of code

        With DoCmd
            .SetWarnings False
            .OutputTo acOutputReport, "rptAffidavit", acFormatPDF, filenamePDF
            .SetWarnings True
        End With

Results with your suggestion: on the new computer. File was not created.

 

[pbaldy]

Does that path exist, and can you create a file there? Does the report open manually?

 

[AngelSpeaks]

Does that path exist, and can you create a file there? Does the report open manually?

Yes it does. I create an Excel file for the same job in the same path. The name is the same except it has an Excel extension

 

[AngelSpeaks]

Well I got the clunker to work and all of the files were created and I was able to open up the pdf files. I'm thinking it's some pdf driver. I do have pdf printers on this computer.

The printers are:

 

[AngelSpeaks]

Clunker's printers:

 

[pbaldy]

I create PDF's on this computer all day long, printers below. Can you open the report manually? If so try creating a PDF from print preview.

 

[AngelSpeaks]

New computer doesn't have Adobe PDF.

 

[pbaldy]

New computer doesn't have Adobe PDF.

Again, it's not required. See post 14.

 

[AngelSpeaks]

I create PDF's on this computer all day long, printers below. Can you open the report manually? If so try creating a PDF from print preview.

View attachment 112744

I created a different report manually with no problem.

 

[AngelSpeaks]

I create PDF's on this computer all day long, printers below. Can you open the report manually? If so try creating a PDF from print preview.

View attachment 112744

OK, I tried the exact report manually and an embedded image wasn't found. When I added the image IT WORKED! Thanks!

 

[pbaldy]

OK, I tried the exact report manually and an embedded image wasn't found. When I added the image IT WORKED! Thanks!

Happy to help! I also mentioned trying that back in post 6.