Recursion in Microsoft Access VBA

Traverse a Folder Structure

A recursive process is a process that calls itself however many times it needs to in order to complete its task.

In this video we will describe recursion and talk through several graphics aimed at illustrating recursion. Then we will examine VBA code that will traverse a folder structure and locate all sub-folders and files within.

The VBA in this video can be found here:

All of my videos organized by topic and other blog topics:

[orange]

Seems links to vba source is/are not working

[andreampere]

Amazing video. Can you give an example, where you traverse beginning from middle node. We need parent and child both. This example is good if we just want to dig deeper not upward. Can you please do a tutorial for going both ways..

[derekboyt]

Good information. I was hoping to gain insight into recursively getting information from the database (since it referenced Microsoft Access in the title) rather than some external source; however, this is a good explanation of how recursion works in general.

[Will-bmcw]

Thanks very much for the great video !
Is it possible to have each piece of the pathway discovered separated into individual components in a query?