473,320 Members | 1,978 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to implement a 'queue'

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
2 2126
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Timothy Madden | last post by:
I want to stoare in a queue values of type LPCTSTR, int, long, BYTE, WORD, DWORD and many enum types. Can I write such a queue in a type safe maner (idealy no casts involved) ? Thank you...
0
by: olsongt | last post by:
This one made me smile. From: http://aima.cs.berkeley.edu/python/utils.html#Queue class Queue: """Queue is an abstract class/interface. There are three types: Stack(): A Last In First Out...
2
by: Thomas Ploch | last post by:
Hello folks, I am having troubles with implementing a timed queue. I am using the 'Queue' module to manage several queues. But I want a timed access, i.e. only 2 fetches per second max. I am...
5
by: DC | last post by:
Hi, I need the functionality to take a workitem from a stack, execute it in a different thread, get the next item, execute it asynchronously too, and so on. But: there should never be more than...
4
by: j_depp_99 | last post by:
Thanks to those guys who helped me out yesterday. I have one more problem; my print function for the queue program doesnt work and goes into an endless loop. Also I am unable to calculate the...
139
by: ravi | last post by:
Hi can anybody tell me that which ds will be best suited to implement a hash table in C/C++ thanx. in advanced
2
by: ecestd | last post by:
how do you implement a copy constructor for this pointer-based ADT queue #include "Queuep.h" #include <cassert> #include <new> using namespace std; Queue::Queue () : backPtr (0), frontPtr(0)...
2
by: ecestd | last post by:
how do you implement a copy constructor for this pointer-based ADT queue #include <cassert // for assert #include <new // for bad_alloc using namespace std; //private:{Queue::Queue(const...
1
by: walsug | last post by:
hello, I'm doing some job concerning code migration from linux to windows,one of the handicaps is the message queue,which is used to do interprocess communication.I've tried several ways under...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.