printing to adobe

[dmb1]

We have a database which produces various reports and we have recently purchased adobe acrobat for the purpose of turning our reports into .pdf and then mergining them etc. is there some code we could use to automatically change the access reports into a .pdf file?

Any help will be great

Dmb1

 

[JoeMiller]

See this web page:

http://www.mvps.org/access/reports/rpt0011.htm

Joe Miller
joe.miller@flotech.net

 

[dmb1]

Have been to the website and put in the code but when I try the final bit:

ChangeToAcrobat
ChangePdfFileName "Name of pdf file including .pdf"
DoCmd.OpenReport "YourReportName", acViewNormal ResetDefaultPrinter

I get a compile error: Expected: end of statement.

Is the code missing something?

dmb1

 

[JoeMiller]

Sorry, I don't have acrobat so I can't troubleshoot the code. I just found the link for it. I would venture to guess though that there may be in an issue in the ResetDefaultPrinter module if it's erroring there. HTH Joe Miller
joe.miller@flotech.net