Newbie Needing To Concatenate Database Field With User Input Field With Set Prefix Follow

0
Avatar
Legacy Poster

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

2 comments

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

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-(selecting-records-from-a-database-at-print-time).aspx

 

http://www.seagullscientific.com/label-software/training-video-(data-entry-at-print-time).aspx

0
Avatar
Legacy Poster
Comment actions Permalink

Thanks. Much appreciated.

Please sign in to leave a comment.