Controling the print dialog window with VBA

[ElGuapo]

I use a database to create a web page with a lot of graphs that I create with Access. For I have figured another way to export graphs from Access to a file suitable for the web I use the Acrobat Distiler to print the reports into pdf files and then publish them. There are multiple graphs on the page and it takes quite some time to create all of them, so I have written a module that prints all of the reports one by one.

The problem occurs when printing to pdf files. The only way I know to control the print dialogs is to use the Sendkeys function. That works just fine on my computer, however when somebody tried to run the program on another computer an error occured. In the print dialog window there is checkbox that controls wether to open Adobe Acrobat after the printing is finished or not. The value of this checkbox has to be set to false, because the opening of Acrobat stalls the program. However the default value of the checkbox depends of the settings of Adobe Acrobat on the computer.

Is there any way I could get the value of this checkbox using VBA code and setting it to false if it is set to true by default?

Thanks in advance!

Rok

 

[GingerR]

hey there-sorry i dont have an answer for you, but how did you make it so that you can print to pdf? what version of access do you have? i do the same thing and would be very interested in automating this tedious task.

sorry i'm off the subject of your question...

thanks--g