These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Issues trying to print MS Access report to PDF

Forum Index > PDF Creation > Issues trying to print MS Access report to PDF
2007-10-11 13:23:16
quantumkev
Registered: Oct 11 2007
Posts: 8

Hello -
I am working on an application that was developed in MS Access, and I have been asked to automate the printing(or saving, as it may be) of reports that were previously saved off as .rtf files. I am working with some API code that was already in the project, but every time I get to the part where it is actually supposed to open the report in design view and change the printer, I get an error saying something to the effect of "The document was previously formatted for printing on My Documents/*.pdf but that printer is unavailable - would you like to print to...."
I have tried everything I can think of, and cannot get the program to recognize that the Adobe PDF printer is installed, and it IS available as far as I know. I have Adobe version 8.0 installed - the full version with the distiller. Does anyone have any ideas that may help? I am working in the VBA behnid the Access. I would greatly appreciate any assistance at all. Thank you...

Top
2007-10-16 08:19:45
#1
iluvstrats
Registered: Oct 16 2007
Posts: 19
Have you tried manually setting the printer to Acrobat distiller and printing the Access report? I only ask because you said you thought that the distiller was loaded but I guessed you weren't sure.
Top
2007-10-29 11:21:54
#2
quantumkev
Registered: Oct 11 2007
Posts: 8
Thank you for the tip. I changed the printer to the Adobe PDF as you suggested, and the reports are now printing to PDF as I had hoped.
I am running into another issue now for which I have posted a new question. When the process runs, it is opening an Access report, printing it to PDF, then refreshing the data for the report for a different customer. The problem is that in the code for the Access, I have to pull up the report by the same name, but when the program attempts to print it out to pdf, it errors out because there is already a pdf report saved off with that name. Can you think of any way to modify the name of the report (add a number to the name, or somethign like that) before it is printed to pdf so this doesn' happen? Again, any help is appreciated.
Top