creating directory

[Phil]

I am using Access 97. I have a form to capture a customer
name, location, project name and job name. Is it possible
to write a macro to create a directory based on the form
information (customername\location\project name\job name)?

Please help

 

[Douglas J. Steele]

Sure. The MkDir statement will let you create directories.

What you need to watch out for, though, is the fact that it cannot create
nested directories. In other words, it cannot create
C:\Folder1\Folder2\Folder3 if Folder1 or Folder2 don't exist. To do that,
you'd need to use:

MkDir C:\Folder1
MkDir C:\Folder1\Folder2
MkDir C:\Folder1\Folder2\Folder3