08 – Arrays And Collections

In this post, we will be taking a look at Arrays and Collections.

Computing is all about sets of similar looking data; appointments, files, pictures, addresses, UDP packets, tracks, database records, patient records, library records, lots of records.  These different data structures inside our programs, computers, hard-drives and memory will be stored as repeating rows making up arrays and collections.  Mostly, computing is about processing these arrays and collections of data, and those arrays and collections is what this unit is all about...

List of topics covered:

  • Declaring Arrays
  • Referencing Arrays
  • Fixed Length and Dynamic Arrays
  • ReDim and Preserve
  • Fixed vs Dynamic Arrays
  • Variant Arrays
  • Erasing an Array
  • Split Function
  • Join Function
  • Multi-Dimensional Arrays
  • Collections
  • Relationships with Objects
  • Properties Associated with Objects
  • Practical Uses of Collections : Form and Report Controls
  • Collections: Control. ControlType
  • Checking if a Form is loaded
  • Referencing Controls
  • Me keyword
  • Full Form Reference
  • Sub Form Reference
  • Common Errors
  • Not Releasing Memory
  • Out of Memory
  • Sloooooow Response Times
  • Exception: Out of Bounds

In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.


In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!

Leave a Reply

Your email address will not be published. Required fields are marked *