Printing Reports with Acrobat Distiller

[speedosteve]

We have written an Access module that prints our sales reports into Acrobat Distiller. It is one master report that is printed by territory, one report at a time based on the sales territory number applied via filter. Each time a report is complete, a dialog box opens confirming the file name in Distiller before the file is saved, requiring me to click "Save" after every file name. One or two is OK but we have 130 sales territories.

Anyone know how I can correctly code into my language how to get the system to automatically accept the default file name assigned by my Access code or is this a Distiller thing? Similar to the vbYes code available in Microsoft.

Any help is appreciated. Thanks.

 

[Uncle Gizmo]

>>>>a dialog box opens confirming the file name in Distiller before the file is saved<<<<<

if I understand this correctly the dialog box is produced by distiller so I would imagine there is nothing you can do from the access end, maybe you should be contacting a distiller bulletin board.

There are other products that allow you to generate P. D. F. files from access reports maybe you should look at these, they might provide the functionality you need (I have no knowledge of the use of them)