Auto Create and Rename PDF Files

[CarlM1975]

Hi

I have a report that I want to print to pdf. I am using docmd.openreport."reportname"

However this produces a dialog box "save as" I want this pre determined in the code. Is this possible?

Thanks in advance

Carl.

 

[darbid]

I found your question interesting but have never done it in Access - but I might have to soon.

I am assuming you understand that like a printer driver you should have a pdf driver to choose from. If not then
http://www.google.cz/search?sourcei...rlz=1T4ACAW_enCZ318CZ321&q=pdf+printer+driver

I am not sure that MSAccess natively will print to pdf meaning you will have to use something like this - which i have not tested yet either.

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=35321&lngWId=1

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21586681.html

http://www.tek-tips.com/viewthread.cfm?qid=1119207