PrestwoodBoards.com
Find Member or Company: 
Find by ID#: 
Tech Search: 
Join Today Sign In
-Collapse +Expand

Access
Search Access Group:

Advanced
-Collapse +Expand Access Group Home◄╣
-Collapse +Expand Message Board
-Collapse +Expand Knowledge Base
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Study Test
PRESTWOODCERTIFIED
-Collapse +Expand Access Store
PRESTWOODSTORE
-Collapse +Expand Members Only
   PrestwoodBoards ► All Groups   

New to PrestwoodBoards?

Sign up, it's free and anyone can join.

Join Today for a free account,
or Sign In if you are already a member.

Access Group

Welcome Guest!

This page is the Access Group home page (summary page).

Microsoft Access

Microsoft Access database system for Windows. Covering all versions of MS Access.

Welcome Access users and programmers!
Welcome to the FREE Prestwood Access group. If you need professional help with MS Access interactive (tables, forms, reports, etc.), Access programming, or converting your Access application, consider us. Visit our Outsourcing Info page for more information.

Want to become a moderator?
We are currently looking for someone to moderate our MS Access message boards. You should be familiar with the interactive featurs of Access and at least the basics of VBA (but you don't have to be an expert). If you're interested, send a private message to Mike Prestwood. Once you are a moderator, you will receive an email whenever someone posts.

Want to become an author?
We are currently looking for authors to post to this group's knowledge base. We are looking for interactive material (tables, forms, reports, queries) and VBA materal. We are interested in both getting started material as well as expert material. If you're interested, send a private message to Mike Prestwood or get started by submitting content to our Access KB Topic (or any subtopic).

Access Content!
Chat!
Access Board:
Posts =  1,591
Threads =  703
Unanswered =  42
Topics =  3
Research!
Access KB:
Articles =  8
News =  8
10 Min Starts =  1
Code =  29
Translate!
To/From Code:
Topics =  49
Code =  660
Study!
eCertified:
Beg Q. =  2
Int Q. =  3
Adv Q. =  2

What's happening now! Access Group!

(New, updated, and unanswered.)

New: Access Message Board Posts
Go To: Access Message Board
 Thread StarterReplies Last Post Topic
Sign In To Check If Stuff Is New
634
Hits
 Form with dependent combo boxes (beginner)
Hello-Very much a beginner at Access here.  I'm trying to create a form for data entry, and may have several questions, but let's start with this one:I am entering data related to employee attend...
0New!
9/26/2008
 MS Access Interactive
Sign In To Check If Stuff Is New
794
Hits
 Starting MS Access
Is it posible to start Access without the access startup showing? how can this be accomplished.
0New!
8/3/2008
 Access VBA Programming
Sign In To Check If Stuff Is New
1603
Hits
 Populating ComboBox...
(Hi, I am using Microsoft Access 2003) Is it possible to populate a ComboBox with choices from more than one field? I've got a couple of different tabl...
13
Ok, I'm pretty much disregarding the above problem. But here's an issue I'm having now, that's a bit...
8/5/2008
 MS Access Interactive
Sign In To Check If Stuff Is New
759
Hits
 Mathematical data in a report..
Hello, I'm using Access 2003, and I have a few questions on a specific report I'm working on, but the first question isn't specific to the report I'm working on...
4
Now I've got a rounding problem..?Okay, got another report; in it are 3 text boxes. 2 of them...
7/16/2008
 MS Access Interactive
More...

Unanswered: Access Message Board

 Thread StarterReplies Last Post Topic
Sign In To Check If Stuff Is New
634
Hits
 Form with dependent combo boxes (beginner)
Hello-Very much a beginner at Access here.  I'm trying to create a form for data entry, and may have several questions, but let's start with this one:I am entering data related to employee attend...
0New!
9/26/2008
 MS Access Interactive
Sign In To Check If Stuff Is New
794
Hits
 Starting MS Access
Is it posible to start Access without the access startup showing? how can this be accomplished.
0New!
8/3/2008
 Access VBA Programming
Sign In To Check If Stuff Is New
834
Hits
 upgrading Access97 DB to Access 2007.
{Too Long}
0New!
7/9/2008
 MS Access Interactive
Sign In To Check If Stuff Is New
665
Hits
 macro won't run on another computer
I have a fairly simple database that I've run for years with no problem. I am now getting ready to be gone for a couple months and am trying to train a coworker on how to use it, but for some reason ...
0New!
12/4/2006
 MS Access Interactive
More...

New: Access Knowledge Base Posts
Go To: Access Knowledge Base
    KB Article KB Topic
Sign In To Check If Stuff Is New  
441
Hits
Code		 1. 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.

3/20/2010
Access & VBA
Sign In To Check If Stuff Is New
517
Hits
Code		 2. Access VBA Empty String Check (Len(s&vbNullString))

Languages Focus: Empty String Check

An empty string is a zero length string, a string tha...

9/17/2009
Access & VBA
Sign In To Check If Stuff Is New
1221
Hits
Code		 3. Access VBA Self Keyword (Me)

Access VBA Self Keyword

Same as VB. The Me keyword is a built-i...

3/11/2009
Language Details
Sign In To Check If Stuff Is New
699
Hits
Code		 4. Access VBA Deployment Overview

Access VBA Deployment Overview

You can deploy your Microsoft Access application either wi...

3/11/2009
Language Basics
More...

New: To/From Code
Go To: Access To/From Guides

Code Snippets

  Code Snippet Created
1. Array 3/20/2010
2. Comments 1/1/2009
3. End of Statement 1/1/2009
4. Case Sensitivity 1/1/2009
5. Literals 1/1/2009
6. Variables 1/1/2009
7. Assignment 1/1/2009
8. String Cancatenation 1/1/2009
9. File Extensions 1/1/2009
10. Unary Operators 1/1/2009

Topics

  Topic Category Created
1. Array Data Structures 3/20/2010
2. Comments Language Basics 1/1/2009
3. Left of String Commands 1/1/2009
4. Prevent Derivation OOP Details 1/1/2009
5. Abstraction OOP Details 1/1/2009
6. End of Statement Language Basics 1/1/2009
7. Case Sensitivity Language Basics 1/1/2009
8. Literals Language Basics 1/1/2009
9. Variables Language Basics 1/1/2009
10. Assignment Operators 1/1/2009

New: eCertified Study Questions
Go To: eCertified
Question Level Type Based on KB Post KB Topic
Arrays in Access VBA are 0 based. 2 TF Access VBA Array (x = Arr... Access & VBA
The default for parameters for subroutin... 2 TF Access VBA Parameters (By... Access & VBA
Access VBA is not case sensitive. If you... 1 TF Access VBA Case Sensitivi... Language Basics
">Given the following ... 2 YN Access VBA Logical Operat... Language Basics
">Given the following code, which MsgBox w... 1 TF Access VBA Logical Operat... Language Basics
In Access object oriented programming, w... 3 MC Access VBA Constructors (... OOP
In Access object oriented programming, w... 3 MC Access VBA Destructor OOP

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
Contact Us   Comment On Page   Report Problem       Email This Page   Printable Version   
 
Who's Online! PrestwoodBoards
301 People Online Now!!  
Online Now: Sign In to see who's online now!  Not a member? Join Prestwood now. It's free!