printing order

[Mike Tobias]

I have an orders database. Late each day, the client runs
a routine to invoice and close the day's (usually between
20 and 50) orders. Each invoice has 3 copies; one for the
customer and 2 for the client. The footer for each is
slightly different.

The routine builds a table of orders ready for invoicing
called "CloseTheseOrders", ordered by a timestamp set when
the order is marked ready for billing.

Then it walks through CloseTheseOrders - for each order, it:
1) Closes the order
2) walks through the footers table, printing the invoice
with the specific footer

After printing all the invoices, it prints a summary report
of orders invoiced, based on CloseTheseOrders.

I have a number of 'num = DoEvents' statements scattered
throughout the routine, which I have added bit by bit,
trying to force things to print in order.

Usually the first few 2 orders print in order, and then the
order becomes moderately garbled. For every 10 orders, on
average, 2-3 sheets print out of order. Very rarely (twice
in the last 6 months), the summary report printed out of order.

I've run out of things to try - help!

Thanks

Mike Tobias
(e-mail address removed)

 

[Guest]

Have you tried ordering the "CloseTheseOrders" table in
the order it needs to print?