print a report to pdf

[fwuttke]

I need some advice how to print a report as pdf file. I have already examinated a couple of newsgroups to find some information regarding this problem. They all recomended setting the default-printer to adobe distiller or changing some registry-keys.
For me these ideas are less usefull because they don't work in a huge multi-user-environment. Has someon experience with the VB pdfWriter-objects which adobe mentioned in its SDK? Has anyone used it? Did it work ?
Has anyone ideas how to resolve this problem even with adobe distiller 3?
Software I am able to use:
1. Access 97
2. Adobe Acrobat
3. Adobe Distiller 3, 4.05
4. Adobe PDFWriter
5. Nothing else...

Thanks
Florian

 

[GHolden]

I use Adobe PDF writer. Once installed it behaves exactly the same as any printer. Assuming you always want the report to go to pdf just set the default printer to PDF Writer, then print from code.



There are two ways to write error-free programs; only the third one works.

 

[fwuttke]

Well, i did this. But I got a couple of problems I cannot resolve:
1. PDF Write starts its work with displaying the save-file dialog box. I'm not allowed to give free filesystem access to a user, and i cannot use sendkeys to close the dialog box programmatically.
2. The report needs to be saved with a different filename. I cannot open report in design view to change reports caption because the hole thing runs under a mdw, which denies access to the reports design view.
3. I need to store the pdf output i a certain folder. So far I know, only the adobe distiller is able to define an output folder.

 

[GHolden]

I had similar problems with PDF Writer.
1. You can completely disable the save as dialogue box, the only thing is, if you do this the report automatically saves to the last place it was saved to. This is fine if you always want the report saved to the same place.
2. Same problem here too. It was resolved in my case because the report was always saved as one of 13 different file names, so I got round it by recreating the same report 13 times with different names(messy, but it worked).
3. As 1, but may not work in your case.

Sorry couldn't be more help....

There are two ways to write error-free programs; only the third one works.