Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to select bulk records in a list box, so I just kept a input box and stored the all values in a variable. But I wish to do the following things.
* Display selected items and failed items count in a text box.
* Display successfully uploaded items and failed items in a list box.
Note: I have tried and got selected items count but not failed items count.
Can any one help me to solve this.
Many Thanks,
Tamil
Have a look at the attached and see if this is what you want - the "listbox" for the excluded values is a tablebox instead just with presentation altered to appear like a listbox.
Hi Aaron,
Thank you for your help. But I need to do one more thing. If I enter values that are not listed in list box, I wish to display them as well. Say for example. 12, -, Aaron (Which not in source data) etc.
=(SubStringCount(vMassUpload,chr(10))+1) - GetSelectedCount(S.No)
would give you the count of any items entered in vMassUpload that aren't found in S.No. Listing them is a little trickier, as if you use a PurgeChar() statement you'll lose a "12" if there's a "1" or "2" in the box. Also be wary, if a "-" is entered into that variable box it will act as a deselect on the number that follows but then select all other options.
Bit of a minefield...don't really have a good answer, if you were to do it in the script it would be easier as you could loop statements, but you can't do that from an inputbox either so...sorry!