Results 1 to 2 of 2

Thread: Record Moving

  1. Sep 12th, 2001, 12:30 PM #1
    chongo 2002
    chongo 2002 is offline

    Thread Starter
    Lively Member chongo 2002's Avatar
    Join Date
    Apr 2000
    Posts
    106

    Record Moving

    Is it possible using a vb program and a acces database to move records up and down like in a text box and keep them displayed in that order on the next run?


    Like this:


    jack - 7 - teacher
    joe - 4 - garbage man
    jim - 1 - truck driver


    say i move jim so he is first, will the database keep that order it seems to reset on me.

    just wondering thanks.
    Last edited by chongo 2002; Sep 14th, 2009 at 02:52 PM.
    Reply With Quote Reply With Quote
  2. Sep 12th, 2001, 12:37 PM #2
    chrisjk
    chrisjk is offline
    PowerPoster
    Join Date
    Jul 1999
    Posts
    5,923
    Only if you had some sort of field containing a "position" value, then you could do a simple ORDER BY to put them in the right order
    jack - 7 - teacher - 3
    joe - 4 - garbage man - 1
    jim - 1 - truck driver - 2
    That would mean it shows like this
    joe - 4 - garbage man - 1
    jim - 1 - truck driver - 2
    jack - 7 - teacher - 3
    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