Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > TechHelp > Directory > Access > Arrays < Random | For Each Loop >
Back to Arrays    Comments List
Dimension Arrays Upload Images   Link   Email  
Juan C Rivera 
WOW this is my biggest problem don't use it much but still like to use it when needed.  Way back I did a D&D character gen for stats.  then killed the code with a bunch of if then looking at the stats to determine if it can be a type class (i.e. Fighter, Cleric..) you video sparked my curiosity again.  So I looked at my code and what a bunch of spaghetti code this is... LOL  So thinking, with multi array can the stats for minimum class be done and if the class meets minimum have a list box populated with the class the character can be?  Knowing Richard the answer is yes... Can you show me so I can learn?

V/r
Juan
Kevin Yip
The problem with arrays is that you have to know the dimensions when you use it, declare it, loop with it, etc.  This is less flexible than a collection data type.  You don't have to know a collection's upper limit to loop through it.  If you need to know its upper limit, you can use its Count property:

    For Each c In Me.Controls
         MsgBox c.Name
    Next
    MsgBox "Number of controls: " & Me.Controls.Count

And if you want to raise its upper limit, you just add items to it.  With arrays, raising upper limit requires the use of the ReDim statement to specify a new upper limit which you may not even know.

So I've rarely used arrays anymore.  Object-oriented programming provides a much more flexible way to handle sets of data.  It has to do computer memory allocation.  Arrays require contiguous blocks of memory, whereas objects do not.
Juan C Rivera
Thanks Kevin, I still will like to learn how to use it.  

V/r
Juan

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Arrays.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/4/2024 6:17:25 AM. PLT: 0s