Form Vbscript To Display Related Data From Dropdown Selection
Hi
I'm trying to design a label and a print form so that when you select a Product code from a drop down menu it will display all the related data from an Excel Sheet.
Now Ive got the vbscript to gather the data in to the dropdown but I cant get it to select all the information related to that product code ie Description , Customer Product Code, QTY etc
I've attached the 2 formats and the excel format
Also is there a way that once the operator chooses the product code they dont go through the next process of the database selection of the records?
Im using Bartender Enterprise 10
Thanks in advance
-
no reply for 8 days now?
0 -
Hello Rob,
You are getting repeated record selection as you are connecting two times to the same database. On one hand you are using BarTender's supported connection and on the other hand you are creating a new connection through your VB Script. Unless you wish to connect to two different databases you should only use on of these.
Also for your reference I'm attaching an example we developed that does two things:
1. Fills a drop down list from an Excel spreadsheet.2. Uses the choice selected in the drop down list to query the database again to retrieve records that match the selection.The code used might be helpful as a starting point or to use as reference.0 -
I'm afraid that I can't attach the Excel file, so you will need to recreate it yourself. It's quite simple, basically two fields with a few records and saved with the name "Fruit.xls". I'm attaching a screenshot for your reference.
0 -
Hello Rob,
You are getting repeated record selection as you are connecting two times to the same database. On one hand you are using BarTender's supported connection and on the other hand you are creating a new connection through your VB Script. Unless you wish to connect to two different databases you should only use on of these.
Also for your reference I'm attaching an example we developed that does two things:
1. Fills a drop down list from an Excel spreadsheet.2. Uses the choice selected in the drop down list to query the database again to retrieve records that match the selection.The code used might be helpful as a starting point or to use as reference.Can you please re attach the file with a lower ver like 9.4
0 -
Attached document saved with version 9.4
0
Please sign in to leave a comment.
Comments
5 comments