473,372 Members | 1,236 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 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 1805
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Tony Williams | last post by:
I have an Access database that we use as a document index system. The documents can be Word, Excel, pdf's etc I have a command button on a form that opens the document in whatever program is...
11
by: cybertof | last post by:
Hello, Is there a way to easily print a .pdf file to the printer ? (without an external component) Thanks.
11
by: Paul Tremblay | last post by:
Hi, I can't seem to locate the visual C++ (pre .NET) ng. This may be slight off topic here - please point me to the correct ng if it is. Without going into much detail (and repeating myself...
4
by: Al Jones | last post by:
Well, hopefully that title get someones attention. In this old gwbasic program I've converted I *have* sucessuflly converted it to print to a file and the output is acceptable. From there I have...
1
by: hamil | last post by:
I am trying to print a graphic file (tif) and also use the PrintPreview control, the PageSetup control, and the Print dialog control. The code attached is a concatination of two examples taken out...
4
by: Rob Meade | last post by:
Dear all, We have purchased a product called SA-FileUp which we have used in our organisation for a number of years, I'm quite an an avid supporter of it, recently I've been trying to ensure...
2
by: Matt | last post by:
We have clients asking that we provide an easy way to print envelops from within our web applications. These envelopes need to be pretty advanced, and need to include a bar code and maybe even a...
7
by: Iain Wilson | last post by:
I am pulling my hair out trying to print various objects from a .net web page My apologies for cross posting but I need an answer and my previous post has attracted no interest. ASP.Net 2.0...
2
by: Iain Wilson | last post by:
Hi Mike I have changed the code using Server.MapPath but to no avail. Prints the Adobe PDF document to the default local printer (I am running this localhost). I Have not run it on the server...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.