Acrobat failed to send a DDE Command

[Jonas]

I am trying to print some PDF documents via MS Access. I get a
message that says, "Acrobat failed to send a DDE command." The
documents open up one after another but do not print. When I get to
around the 50th document, I get the above message. I recently got a
new version of Acrobat Reader, 9.0. Does this error message have
something to do with the registry? Below is some code.

ADOBEPATH = "C:\Program Files\Adobe\Reader 9.0\Reader\AcroRd32.exe"
PDFFILE = tempname2

Shell """" & ADOBEPATH & """/p /h """ & PDFFILE & """"""

[James A. Fortune]

I don't see anything obviously wrong. Maybe 50 queue up while the
first one is printing and the queue is limited.

From:
http://stackoverflow.com/questions/619158/adobe-reader-command-line-reference

/n - Launch a new instance of Reader ever if one is already open
/s - Don't show the splash screen
/o - Don't show the open file dialog
/h - Open as a minimized window
/p <filename> - Open and go straight to the print dialog
/t <filename> <printername> <drivername> <portname> - Print the file
[to] the specified printer.

Perhaps /n or one of the other command line options will solve your
problem. If not, have Access wait awhile before sending each print
request so that several print jobs can finish first to keep the queue
below 50.

James A. Fortune
CDMAP...@FortuneJames.com

[Albert D. Kallal]

?"Jonas" wrote in message
news:3cdaa1fd-71b6-45de...@g10g2000vbv.googlegroups.com...

>I am trying to print some PDF documents via MS Access.

Try this:

CreateObject("Shell.Application").Namespace(0).ParseName("c:\mypdf\myDoc.pdf").InvokeVerb
("&Print")

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenos...@msn.com