Wrox Programmer Forums
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 12th, 2007, 11:58 AM
Friend of Wrox
Join Date: Oct 2006
Posts: 114
Thanks: 0
Thanked 0 Times in 0 Posts
Default Print PDF from Form

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...


Sean Anderson

Sean Anderson
Old February 20th, 2007, 09:18 AM
Registered User
Join Date: Feb 2007
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts

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

Old February 20th, 2007, 10:11 AM
Friend of Wrox
Join Date: Sep 2003
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to leehambly


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.



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to print PDF from a child window disto Javascript How-To 3 September 20th, 2007 05:04 AM
Print to PDF from Access donrafeal7 Access VBA 5 February 25th, 2007 11:30 PM
Print to PDF - Can This Be Done? gwenharrison Access VBA 5 January 11th, 2007 05:02 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.