By Richard Rost 5 months ago
Static Arrays in Microsoft Access VBA. Dice Roller.
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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!"
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
Subscribe to Arrays
Get notifications when this page is updated