Creating a new folder from an Access form

[Guest_imported]

Hello,

I have a database which collects data from several users. This data is often complex, requiring the user to copy and paste files (from excel, word, power point) into a specific folder/directory. I am currently using a merge function to transfer data between Access and the other office documents.

The next step in making the database user friendly is to have it create new folders for these other office documents. Ideally it would name these folders based on the table row "ID".

I have been searching for a few days and have yet to find an example of how to do this. Thanks in advance for you help.

 

[Psychpt]

MkDir creates a new directory in access