DuncanK (duncan (AT) mccarthy DOT co DOT nz) <duncan@clear.net.nz>
wrote:[color=blue]
> Hi there!
>
> I want to implement a 'queue' of records that are prioritised
> (development tasks in this case). I need to be able to 'move' the
> records up and down the queue to change their priority. New tasks
> would added to the 'bottom' of the queue and completed records would
> disappear off the top.
>
> Any idea how to implement this in Access 97?
>
> Would appreciate emailed answers to duncan (AT) mccarthy DOT co DOT
> nz, but I'm subscribed to this group anyway.
>
> Thanks in advance,
>
> Duncan Kinnear.[/color]
Perhaps a simple record ID that you'd manipulate to "move" items up or
down the list?
ie. if I'm moving item 4 up the list I have to do the following
4 -> 3
3 -> 4
Obviously you shouldn't have duplicate ID's so you may need to "park"
your item temporarily during the "move".
ie.
4 -> tmpID
3 -> 4
tmpID -> 3
--
regards,
Bradley
A Christian Response
http://www.pastornet.net.au/response 
