Damned users! Who do they think they are not being able to click on the right
button?
Seriously, if you are still stuck or get stuck, I think somebody else suggested
using two list boxes but, if they didn't, I'll suggest it now.
I'm using such a set up to select multiple items from a list of over 2,500
items. Populating the first box with them all is almost instant and I can drag
and drop to the adjacent list with the chosen item disappearing from the first
one at the same time.
I haven't yet found a way to multiple-select but picking a few items is fairly
efficient. More than, say, a dozen or so might become tedious...
However, it might be possible to set up something similar and be able to
right-click on whichever list is to be processed or have a ginormous button
under each with the text "Process the ABOVE list" in huge letters!! <g>
Regards,
Alastair.
PS: ~ If you want an explanation of how the two list boxes are manipulated let
me know - it was simple enough with two temp tables but I can't remember the
details off the top of my head (and it's getting late here).
----- Original Message -----
From: [EMAIL PROTECTED]
To: RBASE-L Mailing List
Sent: Monday, May 12, 2008 11:10 PM
Subject: [RBASE-L] - Re: Property commands to select all in listbox?
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
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.16/1427 - Release Date: 11/05/2008
13:08
