How to make Folder with vba

Hello everyone,

I want to make a database in which i can create folder .I can create a new folder in that folder and also import files into it using VBA.

I want to import everything into that file like .doc,Jpg,mpeg all formats.
How can i do this.?

To make new folders I use mkDir("c:\newFolder") but what I want is to replace my text newFolder with the text I write in a textbox, in a form, in the database.

Thanks

I would think you could do something like

Please Login or Register  to view this content.

Thank you so much. That solved the problem but you won't get rid of my questions this fast .
I have a new problem, now I want the folders to be created in the same directory as the database.

Put this in a stand alone code module:

Please Login or Register  to view this content.

And the code would then change to:

Please Login or Register  to view this content.