I want to print a PDF from Access, any ideas?

The following code seemed to be the general consensus, but relies on having Acrobat Reader running at the time of execution, which kind of defeats the object of what I am aiming for.

Dim oChannel As Variant
oChannel = Application.DDEInitiate("Acroview", "Control")
Application.DDEExecute oChannel, "[FilePrintSilent(""" & FileName & """)]"

Any help appreciated...

Regards,

Sean Anderson

__________________
Regards,

Sean Anderson

We use a third party product to do this. It comes from Amyuni. http://www.amyuni.com/en/home/index.php

Sean,

I'm not that hot on Acrobat and all the various bits and pieces in it, but a very basic thing that I have used in the past is to just format the report for the Acrobat Distiller "printer" and then let the user decide what they want to do with it: whether they send it to the Distiller or the local printer or wherever.

Means there is nothing to debug too, which is always nice. And also nothing to change when your company decides to move from one version to the next or whatever... which is even nicer.

HTH,

Lee