Fill In Fields From Database 关注

0
Avatar
Legacy Poster

Hi,

I am relatively new to using Bartender (v9.3) and I have a possibly complex, maybe impossible, question.

I have attached a JPEG image that tries to help convey what I know I will have trouble describing.

On my label, I have SCANNED PART NUMBER (in the JPEG file) something that is created by scanning a barcode on a workorder at the time of printing.

I would like the label to take that data and find it in a column of a database, then fill in "Database A" and "Database B" fields from this information. This may be a partial Excel question also.

I really hope that this question make a small modicum of sense. And any help or insight is greatly appreciated.

4 评论

0
Avatar
Ian Cummings
版主
评论操作 固定链接

I guess you made the part number item a user prompt instead of a database query prompt. See the below training videos on how to connect to a database, including Excel, and how to create a query prompt in order to find and select individual records based on a prompted value.

http://www.bartenderbarcodesoftware.com/label-software/older-training-video-(reading-data-from-database).aspx

http://www.bartenderbarcodesoftware.com/label-software/training-video-(selecting-records-from-a-database-at-print-time).aspx
0
Avatar
Legacy Poster
评论操作 固定链接

Thank you for the information. Each of those links appears to be broken when I click on it though. (File Not Found)

[font=Arial, Helvetica, sans-serif]We are sorry, the file or page you requested could not be located. Please double-check the web address you were trying to reach or select one of the following options:[/font]
0
Avatar
Ian Cummings
版主
评论操作 固定链接

Hmmm, it looks like the URL shortening of the forum is messing things up.

The videos can be found on this page:

http://www.bartenderbarcodesoftware.com/label-software/barcode-label-software-training-videos-older.aspx

Items to click are, "Reading Label Data from a Database or Excel Spreadsheet" and "Selecting Records from a Database at Print Time".

请先登录再写评论。