Printing pdf from MS Access

[rwweiland]

Hello all,

I have succeeded in opening a pdf file in code, but now I need to have Access automatically print the pdf form. Can anyone give me some insite to how to do this?

This is how I am getting the pdf form to open.

wbName = "C:\PMs\" & fName & ".pdf"
appName = "C:\Program Files\Adobe\Acrobat 5.0\Acrobat\Acrobat.exe"
whole = appName & " " & wbName
Call Shell(whole, vbMaximizedFocus)

Thanks,

 

[jrbarnett]

Hi,

I don't know about Acrobat Reader v5, but Reader v6 has a /p option to print the file, so you change your code to:

whole = appName & " /p " & wbName

to trigger the print function.

Not sure if this works with v5, but worth a try.

John