New to VBA - for loops

[lopster10]

Hi guys,

I've literally starting learning VBA a few days ago so plz keep that in mind

I have learnt some of the basics, but im just looking at DAO.
In the following statement, what is the purpose of the - 1 ?? Why is this needed?

For i = 0 to db.TableDefs(0).Fields.Count - 1
Debug.print db.TableDefs(0).Fields(i).Name
Next

Any help appreciated.

 

[PHV]

The Fields Collection may be considered as an an array with option base 0, ie the 1st index is 0 ant thus the last index is the the total number of elements [!]- 1[/!]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[lopster10]

Ahh thank you very much, I wasnt thinking about how the individual fields would be returned, my bad.

Regards