Nested Loops in Microsoft Access VBA: Build Multiplication Tables & Simulate D&D Dice Rolls

preview_player
Показать описание
In this Microsoft Access tutorial, you will learn how to effectively use nested loops. We will start by introducing what nested loops are and why they are useful in Microsoft Access. Then, we will look at the structure of nested loops, understanding the interaction between the inner and outer loop. We will build some multiplication tables and simulate dice rolls with a D&D character stat generator. Fun stuff!

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

VBA LOOPS SERIES:

RECOMMENDED COURSES:

SYNTAX:
For X = 1 to 10
For Y = 1 to 5
' Your Code Here
Next Y
Next X

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

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, nested loops, Microsoft Access VBA, loops in Access, nested loop structure, inner loop, outer loop, loop interaction, multiplication tables, dice rolls, D&D character stat generator, loop examples, Loop database, for loop, while loop, D&D Dice Roller, simulating dice rolls, total rolls, individual dice, ability scores, display results, Run-time error '9', subscript out of range

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Рекомендации по теме
Комментарии
Автор

Great video Richard! Love the "Old School" D&D! FYI, I modified your Status box routine to accept 2 Booleans. One to clear the statusbox and another to control the order of the text being displayed (i.e. S & Statusbox or Statusbox & S)

Shadow.Dragon
Автор

What about using format "###" Instead of "000"

xavierbatlle
welcome to shbcf.ru