[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


HP 4300dtn prints reports out of order

Posted on 2005-05-13
Medium Priority
Last Modified: 2012-06-21
I am sending reports from MS Access 2003 to our HP4300dtn printer, and the reports are getting printed out of order. Our Access application is set up to print 1 copy of multiple reports with a single button click. So, this amounts to several print jobs being sent to the printer at the same time. The print jobs are generated on a daily basis, and the print jobs need to be printed in a specific order, because there are too many to have to perform a daily manual sort. The printer is network-capable, and I have noticed this same problem whether the print jobs go over the LAN or directly from computer to printer (via LPT1). I have also noticed that there are no other print jobs being sent to this printer, so the order isn't being affected by someone else trying to print to the same printer. Does anyone have any clues as to why this could be happening?
Question by:dubbelyoo

Expert Comment

ID: 14000296
The printer can't change the order of jobs sent to it. I would say that Access is sending them out of order.
LVL 93

Expert Comment

ID: 14001622
you can try repairing or reinstalling OFFICE
LVL 39

Accepted Solution

hdhondt earned 750 total points
ID: 14001742
Windows is a multi-tasking operating system. It looks as if the reports are all running simultaneously, and the first one that finishes is printed first.

To avoid this happening, your macro would need to check that each report is finished (i.e. put into the print queue) before the next one is started. Jobs that are in the queue they will be printed in the order they arrive in the queue, i.e. the order in which they are listed if you double-click on the printer.
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Expert Comment

ID: 14006083
I agree with hdhondt. This is a setup problem in Microsoft office. You can find the solution in the Office help sections, although it takes some effort.
LVL 21

Expert Comment

ID: 14007156
Try setting the spool option to "start printing after the last page has spooled".
Any other setting (i.e. "print direct to printer"  or "start printing after first page is spooled") will result in a short report being printed first.
Also untick "collate" in the Access print dialogue (the first screen you see after hitting print).
LVL 39

Expert Comment

ID: 14008956
I may be wrong, but I don't think it'll help: these appear to be multiple print jobs. Driver settings won't affect their appearance in the queue. Also, printing "direct to printer" will stop a PC connected via LPT1 from doing anything else until the print jobs finishes.
LVL 21

Expert Comment

ID: 14014635
You may be right, but spooling doesn`t always follow the "rules". Thought it might be worth a try.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you use a Brother DCP 130C or similar Brother printer, at some point you might encounter the following problem: after you change the ink cartridge, the printer displays an "ink empty" message. Sometimes you just need to follow the instructions…
How to solve seemingly unsolvable printer issues. Users sometimes run into printing issues where all the normal steps do not seem to work. Well the steps below can show users how to take one extra step beyond the normal steps needed to remove old…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question