Visual Basic 6 data structures

Question

What are all the build in data structures for VB6 (Microsoft Access) ? I know there are arrays, but are there other more modern data structures?

Are you asking about VB6, or about VBA in Access? – David-W-Fenton May 29 '09 at 04:04 — David-W-Fenton, May 29 '09 at 04:04

score 5 · Answer 1 · edited May 23 '17 at 12:30

5

Disconnected recordsets can also be useful: syncing two lists with VBA

edited May 23 '17 at 12:30

Community

1
1

answered May 27 '09 at 16:10

Fionnuala

89,471
7
106
145

score 4 · Accepted Answer · edited May 23 '17 at 12:30

4

It has a Dictionary: Does VBA have Dictionary Structure?

And Collection: VBA: Resources for Python Programmer

edited May 23 '17 at 12:30

Community

1
1

answered May 27 '09 at 14:45

Mitch Wheat

288,400
42
452
532

1

The dictionary is *not* a VBA data structure, but it's usable in VBA simply because a COM object (the scripting runtime) provides it. – David-W-Fenton May 29 '09 at 04:09
@David W. Fenton is of course correct. Both of those COM objects are commonly used in VBA. – Mitch Wheat May 29 '09 at 09:07

score 3 · Answer 3 · answered May 28 '09 at 18:33

3

The excellent book Hardcore Visual Basic by Bruce McKinney includes some code for creating linked lists, stacks, etc. as part of its introduction to object-based programming with VB6. The book is now available free online.

answered May 28 '09 at 18:33

MarkJ

29,710
5
64
108

score 2 · Answer 4 · answered May 29 '09 at 04:12

I don't think I understand the question. When I read it, I thought of:

Arrays
Collections
Types
Enums

and so forth. Not sure if I'd consider standalone class modules as part of the answer, as they can have any structure you want, rather than being a particular data structure. And, of course, VBA being COM-based, it can use any data structure from compatible COM objects. This may or may not require a type library (depends on the COM object's implementation).

Yah my first instinct was to explain Types. – Oorang Jun 02 '09 at 04:34 — Oorang, Jun 02 '09 at 04:34

score 1 · Answer 5 · answered May 28 '09 at 11:55

1

You can also create your own (better accessibility/performance XML collections) in this way:

MS XML Collections

Also consider using hashtables:

Hash Tables

answered May 28 '09 at 11:55

miPwn

1,168
1
13
29

score 1 · Answer 6 · answered Jun 02 '09 at 11:07

I written quite a lot of code in VB6 and for sure I used Dictionary and Collection classes a lot. But I still think that they are not enough in many cases, that's why I advise you to take a look at this library:

http://sourceforge.net/projects/vbcorlib/

that it's a port of .NET libraries to VB6.

Visual Basic 6 data structures

6 Answers6