Wait for PDF printing to stop before next code

[John]

I have code that opens and prints a report using the Adobe PDF printer
driver. The problem is that Access VB executes the next step in code
before the PDF "Printer" is done "printing". Since the "printing"
happens outside of Access's control, Access thinks the printing is done
too early and moves on---but Adobe is still working.

I've tried the DoEvents, but that doesn't help...probably because the
PDF "Printing" process in not linked to Access. How can I get access to
wait for the pdf to stop "printing" before Access moves on?

TIA...

[nicolec]

John wrote:

I have code that opens and prints a report using the Adobe PDF printer driver. The problem is that Access VB executes the next step in code
before the PDF "Printer" is done "printing". Since the "printing"
happens outside of Access's control, Access thinks the printing is done too early and moves on---but Adobe is still working.

I've tried the DoEvents, but that doesn't help...probably because the
PDF "Printing" process in not linked to Access. How can I get access to wait for the pdf to stop "printing" before Access moves on?

TIA...

In a similar situation, I have this:

objWord.ActivePrinter = "Adobe PDF"
objWord.ActiveDocument.PrintOut printtofile:=True,
outputfilename:=PSfilename

Do While objWord.BackgroundPrintingStatus > 0
Sleep (1000)
Loop

I am sending the print command to a dynamically generated Word doc
instead (objWord.ActiveDocument), but perhaps you can modify to suit
your particulars.

Nicole

[John Mishefske]

ni*****@namg.com wrote:

John wrote:

I have code that opens and prints a report using the Adobe PDF

printer

driver. The problem is that Access VB executes the next step in code
before the PDF "Printer" is done "printing". Since the "printing"
happens outside of Access's control, Access thinks the printing is

done

too early and moves on---but Adobe is still working.

I've tried the DoEvents, but that doesn't help...probably because the
PDF "Printing" process in not linked to Access. How can I get access

to

wait for the pdf to stop "printing" before Access moves on?

TIA...

In a similar situation, I have this:

objWord.ActivePrinter = "Adobe PDF"
objWord.ActiveDocument.PrintOut printtofile:=True,
outputfilename:=PSfilename

Do While objWord.BackgroundPrintingStatus > 0
Sleep (1000)
Loop

Can't you just specify don't print in the background?

objWord.Application.Options.PrintBackground = False
or
objWord.ActiveDocument.PrintOut Background:=False

I think that works, but its been awhile since I dealt with this...
--
'---------------
'John Mishefske
'---------------

[nicolec]

The Access code doesn't stop just because Word is printing, it forges
ahead. This is probably a good thing overall. I actually put the
pause step later down in the code so that Access can complete as much
work as possible, and it's only the larger docs that take longer to
print that ever end up pausing the program. (Pause before it gets to
the section where I need to do something with the finished file, that
it.)

However, the original poster might not be using Word -- I was just
posting an example of a loop that will pause code, since he seemed to
be headed in the that direction anyway.

[John]

I'm not using Word...only Access. I've had to work around the problem.
Thanks for the suggestions tho!
ni*****@namg.com wrote:

The Access code doesn't stop just because Word is printing, it forges
ahead. This is probably a good thing overall. I actually put the
pause step later down in the code so that Access can complete as much
work as possible, and it's only the larger docs that take longer to
print that ever end up pausing the program. (Pause before it gets to
the section where I need to do something with the finished file, that
it.)

However, the original poster might not be using Word -- I was just
posting an example of a loop that will pause code, since he seemed to
be headed in the that direction anyway.