Creating folders through access

[cbende2]

Hello all,



I'm looking for a way to create folders in window explorer through the click of a button in access.

I would like for it to generate a nest of folders based on the different fields in my record.

When the user clicks a button, It takes Field1 and creates a folder(only if Field1 doesnt already have a folder), then it creates a subfolder in Field1 with Field2.

So the path would be R:\Field1\Field2

Any help would be greatly appreciated, or if anyone can reference me to something similar that would be a great as well!

Thanks

[nick404]

Could use MkDir(file path) function.

This may help you: http://www.techonthenet.com/access/f...file/mkdir.php
The FAQ on the bottom shows how to check for an existing directory and if not then create one.
Hope it helps!

[cbende2]

Thanks nick, I came across some code that was similar to what I needed and made the adjusted fixes.