Form Vbscript To Display Related Data From Dropdown Selection Follow

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 comments

0
Avatar
Legacy Poster
Comment actions Permalink

no reply for 8 days now?

0
Avatar
Fernando Ramos Miracle
Moderator
Comment actions Permalink

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
Moderator
Comment actions Permalink

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
Comment actions Permalink

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
Moderator
Comment actions Permalink

Attached document saved with version 9.4

Please sign in to leave a comment.