|
|
Subject:
Access Printing Problem - Hammer?
Category: Computers > Programming Asked by: bselltiz-ga List Price: $10.00 |
Posted:
26 Aug 2003 15:47 PDT
Expires: 18 Sep 2003 05:55 PDT Question ID: 249045 |
I am printing a report to a label printer for labeling inventory. The exact code is: DoCmd.OpenReport strReportName, acViewPreview, , strDataFilter If lngPrintCount > 0 Then DoCmd.PrintOut acPrintAll, , , , lngPrintCount DoCmd.Close acReport, strReportName End If The problem is that the first label keeps coming out blank. The weird thing is that if I put a break in the code at the first line and then click the run button then the first label prints properly although I have done nothing different other than stopping the code. I have tried running a loop to slow things down, tried to repaint the object (report) - nothing seems to work. The entire process happening before the print is a bit involved and I would rather not have to get into it here. I can tell you that it is a Dymo label writer 330 printer and that I am setting the printer by opening the report hidden first, then setting any report properties I need then reopening the report using the code above. |
|
There is no answer at this time. |
|
Subject:
Re: Access Printing Problem - Hammer?
From: hammer-ga on 27 Aug 2003 03:58 PDT |
Hi Brian, I'm afraid I don't have this label printer, so I can't set up a testbed to see what it's waiting for. Perhaps one of the other Researchers can help you out. - Hammer |
Subject:
Re: Access Printing Problem - Hammer?
From: bselltiz-ga on 27 Aug 2003 12:26 PDT |
Hey Hammer, I don't think the label printer is the issue. I'm thinking this would be more of a known access problem when printing. The key is that if I stop the code at the line after opening the report, then click run, without doing anything else, then everything works fine. Brian |
Subject:
Re: Access Printing Problem - Hammer?
From: anonytmouse-ga on 29 Aug 2003 20:40 PDT |
Try putting a DoEvents statement in where you break. |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
Search Google Answers for |
Google Home - Answers FAQ - Terms of Service - Privacy Policy |