Linking Drop Down List To Barcode Field S’abonner
I really need your help. I'm really not a programmer but I managed to follow the forums and read a lot to complete the following script. I could really use your guidance to complete the following scenario. On the data entry form I have a drop down list that selects the different types of labels that we need to print. It takes the information from an excel database. This is working fine. Here is my script:
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Users\jolague\Documents\Label Printing\Product UPC Registration Database.xls;" & _
";Extended Properties=""Excel 8.0;HDR=YES;"""
Public Function CATNUM1()
Set objConn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
rs1= "SELECT * FROM [Sheet1$]"
Set rs = objConn.Execute (rs1)
strNames = ""
do while NOT rs.EOF
strNames = strNames + rs.fields("Reference #") + vbCRLf
CATNUM1 = strNames
However, the part that I don't know how to fix is that each of the items in the Reference # column in my database has an assigned barcode GTIN that needs to print as well as the value in my dropdown list. In other words I need the barcode to follow whatever reference # I select. How can I link the two fields to print all the information on the label? Can a single entry (selection of product to print in dropdown list) be enough to print the product and the barcode?
Vous devez vous connecter pour laisser un commentaire.