Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Queue 2

Status
Not open for further replies.

sera

Technical User
Jun 29, 2000
360
US
Does anyone know if there is a queue data structure in VBA? If so can you point me to some type of source or give me some key words to search(like maybe some syntax)?
Sera
 
If you mean "queue" like a temporary holding queue for multiple records you might try using an array, if your not looking for a holding queue give me an example and I might be able to help further.
 
That will work fine. I am just looking for a queue data struct. I can use an array. I guess what I am really interested in is what data structures that I have available to me in the Visual Basic for Applications package...similar to C/C++ Standard Template Library. I guess this is why I took a course in data structures...if I have to build one then I can.
Thanks,
Sera
 
I don't know of a queue struct. The help file doesn't mention one. As CautionMP mentioned, you can use an array. If you need to queue records, you can use a recordset object.
 
Hi Sera!

If you can build a class in Access like in C++ I am not familiar with how you do it. You can create your own data structures and then declare arrays with them. You can also create Put and Pop functions(public of course) that can control the FIFO logic of a queue. Since you are familiar with queues you most likely can handle it this way, if you need some ideas, let me know.

hth
Jeff Bridgham
bridgham@purdue.edu
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top