Skip to main content
Deutsch Español Français 日本語 简体中文 繁體中文

Search

Search

Different quantity on the last page

Helen Roberts

Hi, I regularly have this particular issue.  We use bartender to print box labels. I have various excel spreadsheets which are connected to  label templates. Often the quantity of items in a box has to appear on the label.  In the excel file there will normally be (e.g.) field A for the number of items in a box and field B which calculates the quantity for the final box (which is inevitably a part box).

I have been unable to figure out a way to do this in a single template in Bartender.  I currently have 2 templates for each customer, one for the full boxes, which looks at field A, one for the part box which looks at field B.  The issue with this is that it means the final part box label is not printed in the same batch as the full box labels.  What would be the best way of producing this in a single template?

0

Comments

7 comments

Date Votes
  • Avatar
    Peter Thane
  • Avatar
    Helen Roberts

    Hi Peter.  Thank you for responding to my question.  I'm attempting to follow your post but I'm struggling on the second lot of VB code for the 'NoOfLbls' field. 

    How is it possible to have 2 different VB coding in the Event Controlled script for one field?  Apologies if this is a stupid question, I'm pretty new to this stuff.

    0
  • Avatar
    Peter Thane

    Good catch, the 2nd one should be for the Items per label value field. I will edit the original.  

    1
  • Avatar
    Helen Roberts

    Thanks for this update, I could have figured that out, apologies for being dense.  

    I'm used to VBA to some extent, this however, I'm struggling with.

    0
  • Avatar
    Helen Roberts

    Hi Peter

    I'm getting the wrong result - it's displaying the Total Count on the first label but is correct on the subsequent labels.  Very strange.  Any ideas where I've gone wrong?

    0
  • Avatar
    Helen Roberts

    Hi again

    I spotted on my screenshot that I'd put the VB code in the wrong category on NoOfLbls, have since moved it to OnNewRecord but it's still giving me the same result.

    0
  • Avatar
    Peter Thane

    I dont seem to have saved that label so have had to rebuild it from the noted from the other post and it all works correctly for me. 

    I would suggest running the NoOfLbls VB to run OnNewRecord and the Items per Label OnSerialise 

     

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post