Reports are not printing in the order they are sent

[Ben Jarnutowski]

Using Access 2002, Windows 2002...

we are having a bit of a problem where reports are
printing out of sequence.

in a module, we set the pointer to a number, then tell
access to open a report at that specific record and print
it. then the report closes, the counter is incremented by
one, the report opens at the next record and is printed,
then closes, this continues until we reach the number of
records/pages to be printed.

This allows us to print many pages individually, and that
part works fine. The reports open at the correct
record/page, and print properly...

The problem we are encountering is that wether we send 50
at a time, or 1500 at a time, they do not print in the
order they are sent to the queue all the time...

we can look at the queue, and see that the documents are
getting there, but as they are printing, they are getting
out of order.

Anyone have any ideas, or soltions to this?

Thanks

 

[Rick B]

Sounds like an issue with the Windows Print Queue manager, not Access. You
might get better response in a different newsgroup that deals more with the
Windows software.

 

[Peter R. Fletcher]

If the Reports are of significantly different lengths, their order may
be being "optimised" byt the queue manager - there are a number af
administrator-accessible settings available that allow this.
Typically, short print jobs will be scheduled ahead of very long ones,
and the definitions of "short" and "very long" are configurable.

Sounds like an issue with the Windows Print Queue manager, not Access. You
might get better response in a different newsgroup that deals more with the
Windows software.

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher

 

[Ben Jarnutowski]

I looked at the size of the reports, they are all the
same size. (only thing printing is a name and an Id
number), and each report is opening, formatting, sent to
the printer within seconds.

I'd look at the administrator accessible settings, but
wouldn't know where to start.

thanks

-----Original Message-----
If the Reports are of significantly different lengths, their order may
be being "optimised" byt the queue manager - there are a number af
administrator-accessible settings available that allow this.
Typically, short print jobs will be scheduled ahead of very long ones,
and the definitions of "short" and "very long" are configurable.