Need Help Populating A Dropdown List With Data From Excel 追蹤

0
Avatar
Legacy Poster

Hi folks,

I'm new to Bartender software and after sucessfully creating a template for a label using data from a excel file, i'm hitting a wall
 

I cannot get a dropdown list to be filled with data from the excel file, it simply defaults to value 1 or value 2
 

I've tried to use the vbscript I found on this site, (after modification to get the file names and location etc. working) and when tested within the vb edit window, all appears fine

 

However when I click OK an error, #6693 insert the name of a column entry here already exists within the Item test column.

 

If I remove the first entry ion the column being checked, I get the following error, OnFillList(Line 6): : Type mismatch: 'Value'
 

If I change the first value to a random value, I recieve an error, #6693 insert the second name of a column entry here already exists within the Item test column.

It seems the vbscript doesn't like multiple entries of the same value in the column. my column of 900+ rows of data has multiple repeat entries of the same value.

e.g. row 1 column entry Andrew, row 2 column entry Andrew, etc. etc, row 10 column entry Bruce, row 11 column entry Andrew, etc.

So that leaves me with 2 questions;

1. is it possible to populate a drop down list with known values which will be in the column i'm checking to filter only the matching records when printing from the database?

2. is it possible to modify the vbscript to overcome this obstacle?

4 意見

0
Avatar
Shotaro Ito
評論操作 永久連結

Hi,

Drop-down box display text cannot have duplicate value.

However actual value can be duplicated.

have serial number before the display texts, like...

 

op=""

op = op & "001 John" & vbTab & "John" & vbCr

op = op & "002 John" & vbTab & "John" & vbCr

op = op & "003 Carlottta" & vbTab & "Carlotta" & vbCr

 

etc.

Not sure it works fine with 900+ rows, though.

0
Avatar
Legacy Poster
評論操作 永久連結

HI Shotaro, to clarify the number of selections in the drop down list will be around 20 in total. The dataset I'm working with is 900+ rows and in the particular column, there may be many similar values.

 

I'll try and populate a drop down list manually and see if it correctly filters the dataset for printing and report back.

0
Avatar
Legacy Poster
評論操作 永久連結

OK just to confirm the dropdown list doesn't work. I've had to use the sql query which is somewhat problematic as it involves an operator manually entering the selection criteria and I had hoped to remove the potential for human error as much as possible.

 

It seems that this 'non-feature' needs to be addressed, fingers crossed it will be soon.

0
Avatar
Shotaro Ito
評論操作 永久連結

Thanks for update - it looks you need to create front-end application to filter data for the user.

Once the record set got perfect, I recommend that to feed Commander - that keep your app simple.

登入寫評論。