For…Next loops let you repeat a code segment multiple times. In this video, learn how to repeat a task using a For…Next loop.
- [Instructor] Many of the code segments you write,…such as assigning a value to a variable…or displaying a message box,…will just need to run one time.…If you work with record sets…such as tables or queries, though,…you might need to repeat a segment several times.…One common way to repeat code in Access VBA…is to create a ForNext loop.…I'll demonstrate how to use ForNext loops in this movie.…I have opened the course database file,…and I'll press Alt + F11…to move to the Visual Basic Editor.…Here in the Visual Basic Editor…I need a code module, so I will open the Insert menu,…and click Module.…
Now I can create my ForNext loop.…I'll start by typing Sub ForNextEx,…just for ForNext Example,…followed by an open and closed parentheses…with nothing in between…because I'm not expecting any outside variables,…and I'll give myself a little room to work.…First, I'll declare a couple of variables.…So I'll type Dim iCaseCount as Integer.…This could indicate the number of cases…of light bulbs that I'm selling, for example.…
- Working with macros
- Running a VBA procedure
- Debugging VBA code
- Defining variables, constants, and calculations
- Displaying a calculated result in a message box
- Repeating tasks with loops
- Manipulating database objects
- Adding, editing, and deleting records
- Looking up values in a table
- Automating processes with macros
Skill Level Advanced
What you should know1m 38s
1. Introduction to Visual Basic for Applications
2. Define Variables, Constants, and Calculations
3. Add Logic to Your VBA Code
4. Debug Your VBA Code
5. Manipulate Database Objects Using DoCmd
6. Read and Manipulate Table Data
7. Manipulate a Database Using the Application Object
8. Control Forms and Reports Using the Me Object
9. Automate Processes Using Macros
Next steps1m 7s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.