Count Doesn't Reset For Next Label 关注

0
Avatar
Legacy Poster

I've created a serialized label (using an Excel table for input).

The count goes 1 0f 6, 2 of 6, etc for the first record.

The second record the count doesn't reset to 1 of 10, instead it keeps counting up 11 of 10, 12, of 10. etc. How do you reset the '1 of' for each label?

5 评论

0
Avatar
Shotaro Ito
版主

Hello Doug,

I assume you have datasourced number of serialized copy from excel field, and want to reset the serial number for each record.
BarTender doesn't have a setting to reset serial number at every record.

One workaround I know is, use database field as data source and reset that by VB script.

1. Create a text with database field(you can use any field. this is dummy.)
2. On the text's [More Options], VB Scripting tab, Enable VB Script. in OnProcessData event, set script like
[code]Value = 1[/code]
(this is in case you want to reset to 1.)
Then [OK].
(you'll get warning of not reading from Value. in this case this is intentional, so just close script assistant.)
3. On [More Option]'s Serialization tab, enable serialization for the text.

see attached format.
Hope that works!

(To Seagull guys - I'm not exactly sure this is correct way of doing, if any better please post that.)
0
Avatar
Legacy Poster

Thanks Shotaro - I found that there is a VB script Record Change Event - this is where you can set the value = 1.
0
Avatar
Shotaro Ito
版主

Yes, Event Control Script's OnNewRecord makes more sense!
0
Avatar
Legacy Poster

I am using Version 10.1 SR3.

 

(The Serialization Reset window now has an option to reset on every record.)

 

This seems to work very well when I am printing only one copy of each serialized label and in all print previews.

 

But I need to print two copies of each serialized label. When I print two copies, the serial counter (which is used to calculate other values) does not reset with each label. It increments steadily from first label to last label.

Again, this is not evident when I preview a print job — only the printed data shows this behavior.

 

Why is preview DATA different from printed DATA? I have never seen this before.

I am using a query for my data. Is this affecting the detection of new records? If so, why is it only a problem when send data to the printer?

 

Thank you much for any help you can offer!

-sols

0
Avatar
Legacy Poster

When you make a field with the 'serialization' property, the print dialog will say:  a "Copies Per Serial Number" - set that to 2.

请先登录再写评论。