471,573 Members | 1,327 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,573 software developers and data experts.

printing files using native applications with document separators

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

Mar 16 '06 #1
1 1678
On 16 Mar 2006 08:39:28 -0800, "dashyone" <re*******@hotmail.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.OpenReport"
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
Mar 18 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Tony Williams | last post: by
11 posts views Thread by cybertof | last post: by
4 posts views Thread by Al Jones | last post: by
4 posts views Thread by Rob Meade | last post: by
2 posts views Thread by Matt | last post: by
7 posts views Thread by Iain Wilson | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by Vinnie | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.