Insert table values with a folder search files

Hi,

[MS Access 2003]

I'd like to be able to run an existing function on all the folders that are matching a certain search criteria, which is: \*\*\1\ - this means to look for 3rd level subfolders with folder name "1" only.

how do I go over a given folder and search in all its subfolder for a matching folder name?

- sample code will be most appreciated,

Thanks!

look at this thread here, it basically does exactly what you want in excel, you will just need to alter to suit the Access VBA, from the VBA6