Microsoft® Office Access 2007 VBA

Chapter 7. Working with Arrays

IN THIS CHAPTER

Introducing Arrays 93

Declaring a Fixed-Size Array 94

Understanding an Array’s Index 94

Working with Array Elements 95

Arrays with Multiple Dimensions 96

Expanding to Dynamic Arrays 98

Introducing Arrays

With one exception all the variables we have used in previous chapters have been specific as to data type and held a single value. That one exception was the lottery number generator introduced in Chapter 6, “Conditional and Looping Statements.” That code used a different type of variable called an array. An array has the capability to hold a set of values of the same data type. Arrays are often visualized as rows and columns of data, much like a spreadsheet appears to the user. In VBA an array is ...