printing files using native applications with document separators

[dashyone]

Hello,

I am using the ShellExecute feature in VBA to print files with various
types. This feature will open documents in its native format and print
them before closing out. I am using the MS Access "DoCmd.OpenRepo rt"
command to print document separators containing the file name and path
of the next document (slipsheet).

This feature works fine except for one thing: the slipsheets are being
printed/inserted randomly in the middle of documents (not serving its
purpose as a document separator). I would like them to be printed
between the last page of the previous document and the first page of
the next.

Is there some way in VBA to control printing so that a slipsheet is
printed before the first page of every document?

Any input is greatly appreciated

[polite person]

On 16 Mar 2006 08:39:28 -0800, "dashyone" <re*******@hotm ail.com> wrote:

Hello,

I am using the ShellExecute feature in VBA to print files with various
types. This feature will open documents in its native format and print
them before closing out. I am using the MS Access "DoCmd.OpenRepo rt"
command to print document separators containing the file name and path
of the next document (slipsheet).

This feature works fine except for one thing: the slipsheets are being
printed/inserted randomly in the middle of documents (not serving its
purpose as a document separator). I would like them to be printed
between the last page of the previous document and the first page of
the next.

Is there some way in VBA to control printing so that a slipsheet is
printed before the first page of every document?

Any input is greatly appreciated

If I understand you, you are shelling out to each print but presumably the simpler items finish
processing and get put into the print queue before the longer ones.
To get them in sequence you could use Shell and Wait on each item to get them in sequence, though of
course your output could still be broken up if others are printing at the same time.
See
http://www.mvps.org/access/api/api0004.htm