Form Vbscript To Display Related Data From Dropdown Selection 关注

0
Avatar
Legacy Poster

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

5 评论

0
Avatar
Legacy Poster
评论操作 固定链接

no reply for 8 days now?

0
Avatar
Fernando Ramos Miracle
版主
评论操作 固定链接

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
Avatar
Fernando Ramos Miracle
版主
评论操作 固定链接

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
Avatar
Legacy Poster
评论操作 固定链接

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
Avatar
Fernando Ramos Miracle
版主
评论操作 固定链接

Attached document saved with version 9.4

请先登录再写评论。