Access Database Lookup/referencing S’abonner

0
Avatar
Legacy Poster

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

5 commentaires

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

I would be interested in the Video on BarTender’s .NET SDKs: Programmatically Controlling BarTender using C# and VB.NET.

 

Thank you,

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

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
Avatar
Domingo Rodriguez
Modérateur
Actions pour les commentaires Permalien

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:

http://www.seagullscientific.com/label-software/whitepapers/barcode-and-label-software-integration-methods(english).pdf

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

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

Vous devez vous connecter pour laisser un commentaire.