Access Database Lookup/referencing
Hi, noob here.
I have successfully connected an Access database which has two fields (Part Number,QR code).
e.g.
ABC-123, http/web/ABC-123
DEF-234, http/web/DEF-234
My label has static embedded screen data ("part number") and a QR code.
The screen data is "Part number" e.g ABC-123.
at print time - I want BT to lookup the part number field in the DB and return the relevant QR code data
your help is appreciated
-
These training videos should help more than me trying to explain in the forums
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
All of these videos are found on the websites.
0 -
I would be interested in the Video on BarTender’s .NET SDKs: Programmatically Controlling BarTender using C# and VB.NET.
Thank you,
0 -
Hi,
I can't still get it work.
data base :
no. Item# description
1. Item#1, item#1 description
2. Item#2, item#2 description
3. item#3, item#3 description.
How could I just select "item#", ideally from a drop list, and it will show in text1 while item#1 description will show in text2 on the label?
there are other texts I will need to enter when printing the labels and I might need multiple copies. But the item# and description will remain unchanged.
I watched the videos multiple times but can't get it works. Please help
0 -
Are you saying that you're wishing to perform a query prompt at print time (at start of the print job), but then also enter other variable data (via the data entry form in BarTender) for the different labels in your print job?
The frequency for displaying the data entry form is either "once per print job" or "once for every record"? Will the "once for every record" frequency match your needs? Otherwise, I'm afraid that you will need to automate BarTender in the background and develop a sort of front-end app which will recopile the variable data to be printed, and will then assign them to the BT document for printing:
0 -
I am trying to populate a drop down list at print time in a form with values from an Excel (xls) sheet
What is the best way of doing this?
From connection to database to VB code?
Thanks
0
Please sign in to leave a comment.
Comments
5 comments