Printing label with no pause

[Aleathiel]

Hi,

I made a report to print label with bar code on it, the thing is that I'm using a zebra printer and it is making a pause of 1 second between each of them, is there a way to print it without pause. I'm sure there is a way, because from agama program its not pausing. Thanks you in advance.

Nathaniel Bell
Technical User

 

[ideafixer]

Possibly a RAM issue. It may be caching the label. Try hooking it up to another machine or steal some ram and upgrade the PC to see if that helps

 

[Aleathiel]

I'm not sure about that since it is working fine with agama (that is using linux) but is slow with windows, could it be because of windows only? that windows sucks

 

[markphsd]

Is there a special Font you are supposed to use?

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[Aleathiel]

I'm using arial narrow, arial black and a bar code Font.

 

[markphsd]

Does the linux program use some other font?

Some printers have special device fonts that make them print faster.

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[Aleathiel]

I just saw that when I print from access, before printing one label, its says printing 1 of 1, when agama say printing 1 of 1 for the complete list, it look like it is divided instead of one long document, any hint on why it does that or how to correct it?

 

[markphsd]

Yes,

It sounds like you are printing a report that has a filter or criteria restraint for one record.

If instead you print a range of records, with the reported formated correctly, you can print all of the documents at once.

Look at the print command, i bet it's something like
docmd.openreport "ReportName", acviewnormal, "ClientID=" & me!clientID

You have to figure out a different criteria. Some sort of filter for the current recordset you are working with.


Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[Aleathiel]

This is the code for my print button, its print label from a query that give me the one I need, and the the query is based on an odbc pull.

Private Sub Command2_Click()
On Error GoTo Err_Command2_Click

Dim stDocName As String

stDocName = "Report1"
DoCmd.OpenReport stDocName, acNormal

Exit_Command2_Click:
Exit Sub

Err_Command2_Click:
MsgBox Err.Description
Resume Exit_Command2_Click

End Sub

Thanks for your help!

 

[markphsd]

That's strange. Is there any code within the report. Seems like a wizard driven report, so i would guess there isn't.

I would only think then it's from the odbc source. But someone else will have to step in on that, because I don't get it.

Maybe you'll need to do a search on odbc and reports.

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.