Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to Print Lablels with Incrementing Label Number

Status
Not open for further replies.

dmon000

Technical User
Sep 9, 2003
79
US
Hi,

We need to print labels for customer that has a label number on it. I see how to use the on-print event of the detail section of the report (label) to get a number on the label that increments using the following code:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
gbl_line_counter = gbl_line_counter + 1
Me.Line_Number = gbl_line_counter
End Sub

However, we need to store the last number used and then start at the next number when we print the labels again.

What's the best way to do this?

Thanks !!
 



Hi,

Why not store in a table. Maybe that's the only thing in the table. Maybe you have other global elements in that table.

Skip,
[glasses]Don't let the Diatribe...
talk you to death![tongue]

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 



However, If all you're attempting to do is have a unique number on the lable, use the date and time, along with a sequence number, to generate unique numbers for each print job.

Skip,
[glasses]Don't let the Diatribe...
talk you to death![tongue]

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top