Assigning Values From A Matrix

Legacy Poster

• February 02, 2016 11:03

Hi

 

I'm really new to Bartender and although I have some experience of Basic, I'm having trouble making BT do anything, I hope someone can help :)

 

I am using a trial version of 11.0.1 32bit. 2016.

 

I we created a 2D barcode with the details we want, PCode a product code about 12 chrs, Batch a batch code again about 10 chrs long, and Expr a date in ISO yyyymmdd format. each is separated by a ;

 

We want to add some readable fields onto the label, the Product Code, Batch and Expr Date.

 

We have done this by creating text fields linked to the elements in the 2Dmatrix (called Bar Code 2). unfortunately it displays the ; at the end and the date in a unfriendly format.

 

I wanted to create unlinked text fields and use VBA to create values in the text fields from the 3D matrix using VB

 

For example to create the Product Code, in a TextPCode field in the VB script I put

 

value = Left(PCode, Len(PCode)-1)    ' attempting to remote the semi colon

 

However nothing happens and I get an 5901 error when I leave the script editor.

 

I'm not really sure how to assign values to the text field from the 2D matrix, should this happen in the 2D barcode field I want the data from or the empty Text Field I want the data in?

 

I know this is fairly simple and not beyond me I'm sure, but when I do this and try the test script action nothing happens and theres no errors in the output box??

 

I was also wondering what event makes the VB code run, should I see the action on the label as soon as I close the script editor?

 

Regards

Jerry Barrett

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • February 02, 2016 18:54

  Can you attach the file?

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • February 03, 2016 13:23

  Hiya

   

  I have found the problem, I had to declare the text items as named items - Voila ! :)

   

  Thanks

  Jerry

  0

Please sign in to leave a comment.