Mike >>The New Tech way is available on the current update by using the CheckedState property of the item and if it is 'Selected' then move it to the new listbox.<<
Is there an example of this somewhere? David David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, December 01, 2004 10:01 AM Subject: [RBG7-L] - Re: What's the difference > > ----- Original Message ----- > From: "David M. Blocker" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Wednesday, December 01, 2004 9:41 AM > Subject: [RBG7-L] - Re: What's the difference > > > > Great question and great answers, Dawn, Larry and Razzak! > > > > Adding my two cents worth > > > > 1. For me, real estate is the key reason for using a Combo box vs. a list > > box, as Razzak pointed out > > > > 2. Lines are an important feature when displaying multiple columns, a > > reason I lean toward Lookup list boxes > > > > 3. However, the nifty method Mike B developed allows you to circumvent the > > limitations Larry mentioned if you use a VARIABLE user defined list box. > > The list does NOT have to be "typed in by hand" but CAN come from one or > > MORE columns in a table. I just installed an upgrade at a client's that > > does just that. The only limitation I've found of mulitple columns is that > > in order to get them to align in columns, since you can't use the LINES > > feature, you must use a fixed font like Courier. > > > > And Larry, I know you've posted this before, but can you supply some more > > details about the two list box method, allowing users to move data from one > > to the other? > > The Old tech method (Kludge) of multi copy from one to another is on my Spring > 2004 demo, but the button isn't placed between the two listboxes, it is at the > bottom. Just run the Multi Select ListBox portion of the demo to copy from one > to another. > > The New Tech way is available on the current update by using the CheckedState > property of the item and if it is 'Selected' then move it to the new listbox. > > There is another demo on the spring cd that moves an item from one listbox to > another on the OnClick event in the "From" listbox. This is the "Multi Col > Listboxes LFF and Cursor" portion of the Demo. > > I'm thinking about a more comprehensive "How To" Demo that I might put together > on One Form to cover the User Defined Listboxes and Combo Boxes to provide > fully commented code, that will be of help to people still unclear on how these > things work, and provide easily portable code for their own projects. I can > see from the posts that some folks are getting the hang of the mechanics of > these controls, but others are still have questions and in the absence of > understanding, they may be missing the full utilization of these flexible > controls... > > > > > > > > David Blocker > > [EMAIL PROTECTED] > > 781-784-1919 > > Fax: 781-784-1860 > > Cell: 339-206-0261 > > > > David Blocker > > [EMAIL PROTECTED] > > 781-784-1919 > > Fax: 781-784-1860 > > Cell: 339-206-0261 > > ----- Original Message ----- > > From: "A. Razzak Memon" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > > Sent: Wednesday, December 01, 2004 12:11 AM > > Subject: [RBG7-L] - Re: What's the difference > > > > > > > > > > At 04:00 PM 11/30/2004 -0600, Marc Schluter wrote: > > > > > > >What are the advantages / disadvantages between, > > > >in other words why would I use one over the other?? > > > > > > > >DB Look up ComboBox > > > >DB Look up List Box > > > >DB User Defined Combo Box > > > >DB User Defined List Box > > > > > > > > > Marc, > > > > > > That would be a perfect article for FTE! > > > From The Edge: http://www.razzak.com/fte > > > > > > While I prepare the article (time permitting), here's > > > a quick version of a few distinct reasons to use one > > > control (ComboBox) over another (ListBox): > > > > > > General: > > > > > > 01. Available Real-Estate on the Form > > > ListBox requires "fixed" width and height to > > > display list items. > > > > > > 02. Look and Feel > > > > > > 03. See Dawn Oakes and Larry Lustig's comments > > > > > > Specific: > > > > > > A. DB Lookup ComboBox vs. DB User Defined ComboBox > > > > > > 01. DB Lookup ComboBox > > > . Lookups are based on Tables/Values > > > . Can use WHERE clause to customize values > > > . Can show lines > > > . Supported/Documented PROPERTY Commands: > > > - ALIGN > > > - AUTODROPDOWN > > > - COLOR > > > - DROPDOWNCOUNT > > > - DROPDOWNWIDTH > > > - ENABLED > > > - FLATBUTTONS > > > - FRAMEVISIBLE > > > - HEIGHT > > > - HINT > > > - ITEMHEIGHT > > > - LEFT > > > - LISTOPEN > > > - REFRESHLIST > > > - SHOWHINT > > > - SHOWLINES > > > - TABORDER > > > - TABSTOP > > > - TOP > > > - VISIBLE > > > - WIDTH > > > > > > 02. DB User Defined ComboBox > > > . Lookups are hard-coded values > > > . Values can be "Editable" > > > . Lookups can be expressions > > > . Values can be saved to a file > > > . Cannot show lines > > > . Supported/Documented PROPERTY Commands: > > > - ALIGN > > > - AUTODROPDOWN > > > - COLOR > > > - DELIMITER > > > - DROPDOWNCOUNT > > > - DROPDOWNWIDTH > > > - ENABLED > > > - FLATBUTTONS > > > - FRAMEVISIBLE > > > - HEIGHT > > > - HINT > > > - ITEMHEIGHT > > > - ITEMINDEX > > > - LEFT > > > - LISTCOUNT > > > - LISTITEMS > > > - LISTITEMSADD > > > - LISTITEMSADDDELIMITEDTEXT > > > - LISTITEMSCLEAR > > > - LISTITEMSDELETE > > > - LISTITEMSREFRESH > > > - LISTOPEN > > > - LOAD_FROM_FILE > > > - READONLY > > > - SAVE_TO_FILE > > > - SELECTION > > > - SHOWHINT > > > - TABORDER > > > - TABSTOP > > > - TOP > > > - VISIBLE > > > - WIDTH > > > > > > B. DB Lookup ListBox vs. DB User Defined ListBox > > > > > > 01. DB Lookup ListBox > > > . Lookups are based on Tables/Values > > > . Can use WHERE clause to customize values > > > . Can show lines > > > . Supported/Documented PROPERTY Commands: > > > - ALIGN > > > - ALIGNMENT > > > - COLOR > > > - COLUMNS > > > - ENABLED > > > - FRAMEVISIBLE > > > - HEIGHT > > > - HINT > > > - HORZEXTENT > > > - HORZSCROLLBAR > > > - ITEMHEIGHT > > > - ITEMINDEX > > > - LEFT > > > - REFRESHLIST > > > - SHOWHINT > > > - SHOWLINES > > > - TABORDER > > > - TABSTOP > > > - TABWIDTH > > > - TOP > > > - VISIBLE > > > - WIDTH > > > > > > 02. DB User Defined ListBox > > > . Lookups are hard-coded values > > > . Lookups can be expressions > > > . May use external file to load values > > > . Values can be saved to a file > > > . Supports SELECT n, UNSELECT n, CHECKINDEX n > > > and SELECTEDSTATE PROPERTY commands. > > > . Cannot show lines > > > . Supported/Documented PROPERTY Commands: > > > - ALIGN > > > - CHECKINDEX > > > - COLOR > > > - COLUMNS > > > - DELIMITER > > > - ENABLED > > > - FRAMEVISIBLE > > > - HEIGHT > > > - HORZEXTENT > > > - HINT > > > - HORZEXTENT > > > - HORZSCROLLBAR > > > - ITEMHEIGHT > > > - ITEMINDEX > > > - LEFT > > > - LISTCOUNT > > > - LISTITEMS > > > - LISTITEMSADD > > > - LISTITEMSADDDELIMITEDTEXT > > > - LISTITEMSCLEAR > > > - LISTITEMSDELETE > > > - LISTITEMSREFRESH > > > - LOAD_FROM_FILE > > > - READONLY > > > - SAVE_TO_FILE > > > - SCROLLWIDTH > > > - SELECT > > > - SELECTEDSTATE > > > - SELECTION > > > - SHOWHINT > > > - TABORDER > > > - TABSTOP > > > - TABWIDTH > > > - TOP > > > - UNSELECT > > > - VISIBLE > > > - WIDTH > > > > > > Stay tuned for more descriptive version at FTE! > > > > > > Very Best R:egards, > > > > > > Razzak. > > > > > >
