Discussion Locked

Access printing problem

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Microsoft Access 2000 and Hp DeskJet 5150 don't seem compatible. I have a large database with a macro set up to print a purchase order. When I ask it to print, a box appears so I can put in a parameter of which PO I want it to print. Since I got my new printer listed above, that parameter box appears for a split second, then a box appears telling me my printer is printing. Of course, it never prints, because I didn't get a chance to tell it what to print. I have to use task manager to end Access in order to get away from the message box. I can click "Cancel" and the X at the top of the message box all I want, but it never goes away.

5 replies

by nstateo

Your macro use default printer and default setings of printer?What is your OS? Memory management is depending your OS (5150 max 8MB).Increase spooling time.

by alpha48

If your new printer is set as the default printer and was loaded properly, try going back to the grid of your query an using the following criteria---Between [Enter Beginning PO number]And [Enter Ending PO number]. I found this works if the field is properly identified in the table properties as indexed and no duplicates.

Regards.

This discussion is closed to new replies.