Printing Quantity Bases On Database Field X Manual Input Follow

0
Avatar
Legacy Poster

Hi all,

I am quite new to BarTender so I hope someone can help me with the following.

We have got an Excel sheet which I have got connected to a label as the database.
This sheet contains a cell with the amount of products a box contains.

When we receive a productionlist, only the boxes to produce are mentioned.

So basically what we want is the possibility to print the amount of labels by simply entering the amount of boxes.
The program must do the math by multiply this with the amount of products.

Any idea ?

Erik

3 comments

0
Avatar
Philip Dea
Moderator

As of version 9.4, you can only do this if you add some basic VB Script (programming) code.
1) From the "File > Print" menu, for "Identical Copies of Labels", click the "Options" button next to it.
2) Under the "Identical Copies of Labels" tab, select "Set by Data Source" option.
3) Under the "Data Source" tab, select the "Database Field" type and choose the database field storing the number you plan to multiply. Type "1" in the text box below to set default value, then click "More Options"
4) Under the "VB Scripting" tab, tick the "Use VB Scripting" checkbox and click "Edit".
5) This is where you should enter code to do multiplication. e.g., if you enter the line below, the number of labels that will be printed is 2 times the value read from the database field you set in step 3:

Value = CInt(Value) * 2 'cast value as int
[attachment=36:Number of copies determined by VB Script and database.jpg]

Please note that Seagull Scientific does not have the resource to teach or write programs for customers.
0
Avatar
Legacy Poster

[quote name='Philip D - Seagull Support' timestamp='1317360590' post='727']
As of version 9.4, you can only do this if you add some basic VB Script (programming) code.
1) From the "File > Print" menu, for "Identical Copies of Labels", click the "Options" button next to it.
2) Under the "Identical Copies of Labels" tab, select "Set by Data Source" option.
3) Under the "Data Source" tab, select the "Database Field" type and choose the database field storing the number you plan to multiply. Type "1" in the text box below to set default value, then click "More Options"
4) Under the "VB Scripting" tab, tick the "Use VB Scripting" checkbox and click "Edit".
5) This is where you should enter code to do multiplication. e.g., if you enter the line below, the number of labels that will be printed is 2 times the value read from the database field you set in step 3:

Value = CInt(Value) * 2 'cast value as int
[attachment=36:Number of copies determined by VB Script and database.jpg]

Please note that Seagull Scientific does not have the resource to teach or write programs for customers.
[/quote]

Hi Philip, we have managed to get this sorted by using a VBS script.
Thanks for your reply!

Erik
0
Avatar
Philip Dea
Moderator

Hi Erik,

You're welcome. Glad it works for you.

Please sign in to leave a comment.