Bill: I appreciate all suggestions!
However, this doesn't help with what I need. If there's 100 things in the
listbox, and they want 90 of them, they have to click 90 times. I already have
a button to "select all items" -- they don't even have to click into the list
box to do that. But listbox multi-select doesn't support shift-clicking to
grab contiguous ranges, or a hot-key that I know of (like I think it was
shift-F6 or something to select all from a check box menu?)
Alastair: we've decided that the 2 buttons "process all selected" and
"process all EXCEPT those selected" would probably lead to too many user
errors.
I'm working with Jan on his idea -- to add a Y/N field to my temp table,
represent with images, and on-click eeps to turn the Y/N on and off, a button
to turn
them all on/off... Pretty slick once I get it polished, I think.
Karen
> Karen,
>
> Sorry for jumping in on this issue so late but I may have a workaround for
> you.
>
> Create a table called AllThings with one column (AllThings Text 40)
> Load this table with 1 item ('AllThings')
>
> Create a view that includes the items your client wants in the listview.
> I created this view to include a choice for 'All Customers'
>
> DROP VIEW `CustPick`
> CREATE VIEW `CustPick` +
> (CustId,CustName) AS +
> SELECT CustId,CustLastFROM Customers+
> UNION SELECT 'CUSTALL', ' AllCustomers' FRO ALLTHINGS WHERE LIMIT = 1
> RETURN
>
> Note that there is a space in front of the phrase ' All Customers'. In this
> way All Customers will always be at the top of the list.
>
>
> Make your listview lookup based on the view CustPick and order by CustLast
> (or custname or whatever you use)
> This would produce a view that looks like this;
>
> All Clients
> 1234 Adams Corp
> 1235 Baker Company
> 1236 Charles Inc.
> 1237 Delta Co Inc.
> 1238 Edwards LLC
> etc.
>
> Then in my follow-up code if the choice is CUSTALL then I do some code. If
> the choice is not CUSTALL, then you use your code for the multiple selects.
>
> Whats nice about this is you can create any number of listviews for any
> number of tables where you need to select ALL of something from a list.
>
> Then, of course, if Razzak has already come up with a slick update, then
> forget this.
>
> Hope this helps.
>
> Bill Eyring
>
