In this Microsoft Access tutorial, I'm going to teach you how to use static arrays and the Randomize function to simulate die rolls for a Dungeons & Dragons character. We'll define an array to hold six ability scores and another to label these scores with their corresponding stat names like STR, INT, and WIS. This lesson is a perfect blend of learning VBA array basics while having a bit of fun with random number generation.
Members are going to learn how to load the array of stat names more easily using the Array function. There are some additional changes we'll need to make to the code, but it's an overall better solution.
MEMBERS-ONLY EXTENDED CUT VIDEO:
[ Ссылка ]
BECOME A MEMBER:
YouTube: [ Ссылка ]
or My Site: [ Ссылка ]
LEARN MORE:
Arrays: [ Ссылка ]
PREREQUISITES:
Intro to VBA: [ Ссылка ]
Variables: [ Ссылка ]
Status Box: [ Ссылка ]
Random: [ Ссылка ]
For Next Loop: [ Ссылка ]
RECOMMENDED COURSES:
Access Developer 21: [ Ссылка ]
Developer Courses: [ Ссылка ]
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: [ Ссылка ]
Blank Template: [ Ссылка ]
Contact Management: [ Ссылка ]
Order Entry & Invoicing: [ Ссылка ]
More Access Templates: [ Ссылка ]
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: [ Ссылка ]
How to Use Access in 30 Minutes: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
Donate to my Tip Jar: [ Ссылка ]
Get on my Mailing List: [ Ссылка ]
Contact Me: [ Ссылка ]
TechHelp: [ Ссылка ]
Consulting Help: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Static array, array function, variant, load array with values, array loop, breadcrumbs, die roll, dice roll
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
![](https://i.ytimg.com/vi/ZLtwkaPcLkU/maxresdefault.jpg)