Waiting for OLE to finish its task

[SUnderwood]

Gentle Folk

May I call upon your expertise to focus on a problem with an embedded Adode object on an Access form?

I have take to task the Adobe object to print for me, in quick succession, a list of pdf file to a printer, one by one.

Alas the dumbfounded object is quickly overwhelmed by my programs requests and before its had time to consider its first task is will crash with dramatic speed.

Perhaps you can ascertain how I can assist the Adobe object with my tasks, or perhaps a more suitable method of execution is called for?


My best wishes to you in advance,


Sean

 

[BillPower]

You could try placing:

'print report1
DoEvents
'print report2
DoEvents
'print report3
DoEvents
'etc

After each item in your list. Search help for detailed explanation of DoEvents.

Bill

 

[SUnderwood]

Dear Bill

Thank you for your suggestion.

Alas this novel approach I have fore tried and the Adobe object succumbs to the same fate.

I have also coxed the program into submission via the Shell command and awaiting its notification of completion via some clever winAPI commands.

This last idea work, but with appallingly slow results as the program must be allocated system resources, then the system must snatch them back, for each document!

A trifle trick!?

Sean