02 – Multi-Data Type Arrays

In this post we will be demonstrating how using class modules can make your arrays more functional and easier to read!

In the first post we explained how class modules change the way you think about programming. You are now focusing on objects rather than actions. When dealing with arrays that require multiple data types, this idea will become even more apparent and will increase your understanding of class modules further.

Note: This post assumes you have a good understanding of arrays. If you would like to learn more about arrays, please read these posts:
Working With Arrays 1
Working With Arrays 2

Arrays in MS Access allow us to create lists of data in memory which we are then able to manipulate through code. They are similar in design to tables but don't take a physical form. One of the main issues with arrays is that we often need to store data for multiple data types but primitive arrays only allow you to store one data type. So, what do we do?

We use strings!

Let's take a look...

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!