Peripheral·2,142 discussions

Printing Microsoft Access Report as pdf to specific folder

Locked

I have designed a Microsoft Access report which is specified to print to the pdf printer. The code for this action works well, but I am trying to automate the process so that the code can determine which folder to place the file in, determine a file name, and to perform all of these actions without the user seeing a print box requiring any user interaction. I am looking for a method to automate this process.

Topic

Clarifications

In reply to Printing Microsoft Access Report as pdf to specific folder

Clarifications

Printing to File from MS Access

In reply to Printing Microsoft Access Report as pdf to specific folder

yes, good question. that is, how to automate printing files (specifically pdf’s) when the printer driver wants to pop up a dialog box to ask for the output file name. so far, I have found the following links.

http://support.microsoft.com/kb/259971

http://www.groupacg.com/

I’m wondering if there is a straighforward way to do this, WITHOUT using SendKeys, and WITHOUT purchasing a 3rd party control.

The magical solution

In reply to Printing to File from MS Access

Check out http://www.bullzip.com
They have a virtual printer solution like many others (CuteFTP, …). The difference is that this printer checks some ini files for settings. One file (settings.ini) is per user, another (runonce.ini) can be defined from VB(A) (by some bullzip dll calls or throught standard ini file methods) and is deleted after one usage. In this ini file you can tell where to put the pdf, how to name it, you can merge with pre-existing pdf’s or even overlay them.
And the magical part: it’s free (according to the site free for non-commercial usage, according to the installation process free for any usage.)

[Author]

Replies