Nested Loops. Multiplication Tables. D&D Dice Rolls

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!

Members

There is no extended cut, but here are the databases:

•  Database Download - Gold Members

Prerequisites

• Intro to VBA: https://599cd.com/VBA
• For Next: https://599cd.com/ForNext
• While Wend: https://599cd.com/While
• Random: https://599cd.com/Random

VBA Loops Series

• For Next: https://599cd.com/ForNext
• While Wend: https://599cd.com/While
• Do While: https://599cd.com/DoWhile
• Do Until: https://599cd.com/DoUntil
• For Each: https://599cd.com/ForEach
• Nested Loops: https://599cd.com/NestedLoops
• Summary: https://599cd.com/Loops

Links

• DieRoll Function: https://599cd.com/DieRollCode
• Format: https://599cd.com/Format
• String Functions: https://599cd.com/String
• Arrays: https://599cd.com/Arrays

Recommended Courses

• Developer Courses: https://599cd.com/Developer

Syntax

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

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

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, 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