Arrays

When you open a database using DAO you can refer to fields using recordset.fields("FieldName"). Is it possible to create an array that would use String instead of Integer?
ie;
instead of

ReDim Preserve Marek(1)

I would use

ReDim Preserve Marek("Marek")

and then access it using "Marek" as array index?

[parksie]

The DAO 'arrays' are not arrays. They are Collections, which are accessed by a 'key', usually a String value:

Dim MyCol As New Collection
Private Sub Form_Load()
    MyCol.Add "Item 1", "My item"
    MyCol.Add "Item 2", "A different item"
    MsgBox MyCol("My item")
End Sub

They basically deal in Variants all the time, so you can add an item of pretty much any type, although there may be restrictions on indices.