Newbie Needing To Concatenate Database Field With User Input Field With Set Prefix
Hi team, I am brand new to the forum and just got nominated BarTender super user at work. We lost our in-house talent years ago. I am trying to setup my label to print a barcode that has our UPC code (from the database), and the carton quantity (from user input when running BarTender).
I am looking for something like this ' "(02)00" + [item].[itemupccode] + "(37)" + {user input quantity in box}
--where the stuff in " " is constant
--where the stuff in [ ] is from database, which is reading fine by the way.
--where the stuff in { } would need to be prompted to the user to input when or just prior to printing a label.
I don't know VBA the application was asking me for an end of statement which I could not figure out on other websites. I really appreciate any help you can throw my way.
thanks in advance
Yves
-
You should use the application identifier wizard to help build the data sourcing for this barcode. Each application identifier (AI) and matching data should be in its own separate data source. The wizard will help you do this. In this way its easy to set one data source to be coming from the database field, while the other is embedded data with a data entry prompt setup. See the below white paper:
http://www.seagullscientific.com/label-software/whitepapers/gs1-application-identifiers-201406.pdf
These training videos will also help:
http://www.seagullscientific.com/label-software/training-video-(reading-data-from-database).aspx
http://www.seagullscientific.com/label-software/training-video-(data-entry-at-print-time).aspx
0 -
Thanks. Much appreciated.
0
Please sign in to leave a comment.
Comments
2 comments