To/From Code

	Languages
BROWSEBYLANGUAGE Access VBA ASP Classic C# C++ C++/CLI Delphi Delphi Prism Java JavaScript ObjectPAL Perl PHP VB Classic VB.Net

	Categories
BROWSEBYCATEGORY +Tool Basics +Language Basics +Language Details +Data Structures +Statements +Operators +Commands +Database -OOP Basics Base Class Class..Object Inheritance Member Event Member Field Member Method Member Modifier Member Property Member Visibility +OOP Details

	Access VBA Guides
Access VBA To/From Conversion Guides Access VBA and ASP Classic Access VBA and C# Access VBA and C++ Access VBA and C++/CLI Access VBA and Delphi Access VBA and Delphi Prism Access VBA and Java Access VBA and JavaScript Access VBA and Perl Access VBA and PHP Access VBA and VB Classic Access VBA and VB.Net

Cross Ref Guide

ACCESS VBALANGUAGE

Access VBA

ACCESS VBAANDOBJECTPALTOC

Overview

+Tool Basics

Report Tools Overview

+Language Basics

+Language Details

+Data Structures

Array◄╣

+Statements

+Operators

+Commands

-OOP Basics

+OOP Details

	Members-Only
Sign in to see member-only pages.

► KB ► To/From Guides ► Access VBA ► OOP Basics

Array (Cross Ref > OOP Basics)

By Mike Prestwood

Access VBA versus ObjectPAL: A side by side comparison between Access VBA and ObjectPAL.

Data Structures

Data structures allow you to store and work with data. Common data structures include arrays, associative arrays, etc.

Array

[Other Languages]

Languages Focus

A data structure in which individual values (called elements or items) may be located by reference to one or more integer index variables, the number of such indices being the number of dimensions in the array.

Arrays can start with an index value of 0 or 1, sometimes referred to as 0 based or 1 based.

Access VBA: x = Array()

Arrays in Access VBA use a 0-based indice. Use UBound to get the number of elements. UBound returns -1 if the array has no elements, 0 if it has 1, 1 if it has 2, etc.

Syntax Example: 1 certification question.

Dim MyArray As Variant
Dim i As Integer
 
MyArray = Array("Mike", "Lisa", "Felicia", "Nathan")
 
If UBound(MyArray) > -1 Then
  For i = 0 To UBound(MyArray)
    MsgBox (MyArray(i))
  Next
End If

ObjectPAL: Array[] type

Arrays in ObjectPAL use a 1-based subscript (also known as an index). Use [] with a subscript to refer to an element (i.e. MyArray[1], MyArray[2]).

The number of elements for a given array in ObjectPAL are either fixed or resizeable. Specify the size when you declare it for fixed. Use size() to get the number of elements, size() returns 0 if the array has no elements. Use setSize(), grow(), addLast(), etc. to add elements to an array.

Syntax Example:

var
  MyArray Array[4] String ;Fixed size array.
  i LongInt
endVar
MyArray[1] = "Mike"
MyArray[2] = "Lisa"
MyArray[3] = "Felicia"
MyArray[4] = "Nathan"
if MyArray.size() > 0 then
  for i from 1 to MyArray.size()
    msgInfo("", MyArray[i])
  endFor
endIf

ObjectPAL Array (Array[] type) 1 certification question.