looking for a tutorial or detailed infos on how to work with arrays??

[Bas Cost Budde]

Arrays? For a database application?

What do you think you want to do with them?

 

[Bas Cost Budde]

Instead of using an array consider creating your own variable type:
VBA (Access 95 onwards) allows you to return an entire structure of values.

Programmers with a background in C will instantly recognize the
possibilities now that user-defined types can be returned from functions. If
you're keen, user-defined types can even be based on other user-defined
types.

Aha. And programmers with C++ knowledge may even creating Class modules,
extending the type with functions, procedures and properties.

That is definately true, but it depends quite a bit on what you want to
accomplish whether this will do much good. Code needs maintenance. Yes,
SQL code needs maintenance too.

 

[CSmith]

Hi,

That example only demonstrates how to store a SINGLE dataset, which would
not be the same as an array.