Results 1 to 13 of 13

Thread: [RESOLVED] Load listview sorted

Threaded View

  1. May 31st, 2007, 10:22 AM #1
    aikidokid
    aikidokid is offline

    Thread Starter
    Frenzied Member aikidokid's Avatar
    Join Date
    Aug 2002
    Location
    Bristol, UK
    Posts
    1,968

    Resolved [RESOLVED] Load listview sorted

    VB6 - Access 2002 - ADO

    I have this SQL statement, and I know that I need to use 'ORDER BY' to load into a certain order, but I can't seem to get it to work the way I am after.

    vb Code:
    1. strSQL = "SELECT First_Name, Middle_Name, Surname, Memb_ID FROM tbl_Membership"


    I am running this in the form load and then, the bit I am stuck on is trying to have the Listview sorted by Column 3 (Surname)

    How can I sort this by this column?

    Thanks
    Last edited by aikidokid; Jun 20th, 2007 at 02:40 PM.
    If somebody helps you, take time to RATE the post. I do.

    "FAILURE IS NOT AN OPTION. It comes bundled with the software."

    Below are some of the threads that have helped me along the way:

    CodeBank submission:
    Listview Backcolor (without subclassing)

    Loading Treeview Nodes From A Database, Creating Registry Keys, Count Number of Lines in TextBox , Excellent RichTextBox Tricks & Tips
    Ideas & Screen Shots For A Code Library App
    How to do Data validation in Excel, Conditional Formating in Excel
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width