By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,731 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,731 IT Pros & Developers. It's quick & easy.

How to implement a 'queue'

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Br
DuncanK (duncan (AT) mccarthy DOT co DOT nz) <du****@clear.net.nz>
wrote:
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.


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
Nov 13 '05 #2

P: n/a
rkc
DuncanK (duncan (AT) mccarthy DOT co DOT nz) wrote:
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?


As a table, use a priority field and Insert, Update, Delete queries.
In memory, use a VBA.Collection object.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.