Results 1 to 2 of 2

Thread: [RESOLVED] Sorting an Access Table using VB6 and ADO Connection

  1. Oct 5th, 2005, 07:28 AM #1
    manofsteel00
    manofsteel00 is offline

    Thread Starter
    Addicted Member
    Join Date
    Sep 2005
    Posts
    200

    Resolved [RESOLVED] Sorting an Access Table using VB6 and ADO Connection

    At the risk of being redundant, can anyone help me out on how to sort an Access table using VB6 and ADO connection. I'm hoping there's a one line of code to do it instead of looping through all the records. Thanks in advance!
    Reply With Quote Reply With Quote
  2. Oct 5th, 2005, 07:34 AM #2
    dannymking
    dannymking is offline
    Fanatic Member dannymking's Avatar
    Join Date
    Jul 2005
    Location
    Darlington, North East UK
    Posts
    677

    Re: Sorting an Access Table using VB6 and ADO Connection

    By sorting the access table, do you actually mean the table itself, or the data being returned to the VB6 program..

    Short Answer: you cannot in theory sort an access table and it will stay put.. The records are stored in the order they are created irrespective of how it actually looks.

    I presume that you are returning the data via an ADO recordset to the vb program??

    If so then you will need to return the data inside the recordset in the sorted order.
    Danny

    Never Think Impossible

    If you find my answer helpful then please add to my reputation
    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