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

Legacy Poster

• 2014年11月14日 01:20

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

0

• 

  Ian Cummings

  版主

  ★ BarTender Hero ★

  • 2014年11月14日 09:12

  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
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 2014年11月14日 18:49

  Thanks. Much appreciated.

  0

請登入寫評論。