Access

	Access Group Home
Get Started Page eMag: Access Edition Highlights WEEKLYLESSON Week 33 Lesson◄╣ MYGROUPSETTINGS My Group Settings

	Message Board
-New Activity -Unanswered Threads -Most Active Threads -Most Read Threads

	Access KB
-New & Updated -Most Read -10 Min Quickstarts -Recent Comments Tech Articles Access News Resource Links ACCESSTIDBITS: All as FlashCards Code Snippets FAQs Tips

	Access To/From
To/FromCODEGuides Access To/From

	Access Study Test
PRESTWOODCERTIFIED Access Study Test

	Access Store
PRESTWOODSTORE Store Home Buy Access Items

	Members Only
MEMBERSONLY Access Member List Member Only KB Posts Access Content Stats Random Article Random MB Thread Random Tidbit Random CrossRef Code

► All Groups ► Access Group

Print This All Groups

Weekly Access Lesson

Week 33, Posted Monday 8/19/2019

Content changes every Monday @ 1AM!! Check back once per week. Learn! Review! Test Yourself!

Lastest Access Flashcard

Our flashcards are part of our library of tidbits.

Tidbits are FAQs, Definitions, Tips, and Code Snippets from our knowledge base.

Access VBA Array (x = Array())

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

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

Posted By Mike Prestwood, Post #102132, KB Topic: Access & VBA