Sorting a ListView Control

[mrdod]

I was wondering how to right click a header on a ListView control and be able to search for a record? I have seen it used on some purchased software that uses Access and was wondering how the heck it works as it would be a nice feature on my form. I'm not sure what type of control would allow me to do this. Currently I am using Microsoft Listview 6.0. Any ideas?

Thanks

 

[maxhugen]

Although I can't suggest anything re the ListView control, just thought I'd mention that I use a subform as a searchable list.

It uses command buttons at the top as 'column headings' which sorts the column ASC when clicked, and DESC when clicked again.

In the footer section, each column has a textbox that lets users enter criteria they want to search on, across multiple columns, and then filters the subform to show the results.

This also allows the user to filter in several ways. For example, a date column can be filtered (via code) for:

[tt] Null
<7/18/2007
>1/01/2007
1/01/2007 To 7/18/2007[/tt]

Double-clicking any row opens the record in a separate 'detailed' form for editing etc. Works well, users love it.

Max Hugen
Australia

 

[ZmrAbdulla]

If you need to sort the listview then see this code that sorts ASC & DESC. Keep in mind that Listview sorts only in alpha mode. So if you need to sort numerical or date columns then a reload of listview sorted in your SQL is easier.

Private Sub ListView1_ColumnClick(ByVal ColumnHeader As Object)
'   When a ColumnHeader object is clicked,
'   the ListView control is
'   sorted by the subitems of that column.
'   Set the SortKey to the Index of the ColumnHeader - 1
    Me.ListView1.SortKey = ColumnHeader.Index - 1
    ' Set Sorted to True to sort the list.
    If ListView1.SortOrder = lvwAscending Then
        ListView1.SortOrder = lvwDescending
    Else
        ListView1.SortOrder = lvwAscending
    End If
    Me.ListView1.Sorted = True
End Sub

here are some faqs on listview those may help you in your way.
faq702-6025
faq702-6026
faq702-6027

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[cuetzpalin]

Hello,

Do you know where I can find a good example on the double click event you mentioned above? and how you had it bring a "detailed" form?

That's exactly what I'm trying to accomplish.

Thanks!!