Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2008

Tip: Looking for answers? Try searching our database.

Looking for a better listbox

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Max Moor - 05 May 2008 23:36 GMT
Hi All,

       I want a listbox with column sort buttons at the top and adjustable
column widths.  You see them in all kinds of applications, like Windows
Explore's file list.  I could build one for myself using labels with button
down and button up events and a bunch of code to round it out.  Isn't there
something simple already out there that I can drop in?

Thanks for any pointers,
Max
Damon Heron - 06 May 2008 00:29 GMT
How about a subform as datasheet?  You can adjust the columns, sort by
column (simply right-click) and with a little coding make a selection from
the datasheet row.

Damon

> Hi All,
>
[quoted text clipped - 8 lines]
> Thanks for any pointers,
> Max
MikeB - 06 May 2008 00:41 GMT
> Hi All,
>
>    I want a listbox with column sort buttons at the top and adjustable
> column widths.  You see them in all kinds of applications, like Windows

 Those are ListViews.  Access Controls > Additional controls(elipsis)>
Microsoft ListView Control, ver 6.0

> Explore's file list.  I could build one for myself using labels with button
> down and button up events and a bunch of code to round it out.  Isn't there
> something simple already out there that I can drop in?
>
> Thanks for any pointers,
> Max
Max Moor - 07 May 2008 21:05 GMT
>   Those are ListViews.  Access Controls > Additional controls(elipsis)>
> Microsoft ListView Control, ver 6.0

Hi Mike,

       I was afraid of that.  I've put off trying to implement them, as I've
heard so many complains.  I bit the bullet and started in on it, and just
about have it all working for me, though.  So far it's not bad at all.  We'll
see what happens when I try to get fancy some day.

Regards,
Max
Albert D. Kallal - 06 May 2008 01:14 GMT
I find so often that users really don't need the column sizing....

And, the few cases for sorting, I add a combo box at the top of the form.

And, you do get filter by selection for free if you copy the menu buttons.

Here is some screen shots of continues forms I used, and I tend to like them
better then datasheet viewes...

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

Signature

Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Stephen Lebans - 06 May 2008 12:01 GMT
An alternative to a form in Datasheet view is here:
http://www.lebans.com/listboxcolumnresize.htm
ListBoxColumnResize.zip is a Class that allows the user to resize the
ColumnWidths of a ListBox at Runtime.Also supports an Autosizing method for
the ColumnWidths.

Version 2.2 April 27/2002

Modified Columns AutoSizing method to work with both ListBox and Combo
controls.
Signature


HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

> Hi All,
>
[quoted text clipped - 8 lines]
> Thanks for any pointers,
> Max
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.