create directory from a form

  • Thread starter Thread starter Uhl
  • Start date Start date
U

Uhl

I use a field called "Ordner" as Hyperlink with data e.g. "C:\Customers".
I also use a field named "Lastname" as Text with data e.g. "Miller".

Now I want to create a directory Miller in C:\custmers

Result: C:\customers\Miller

Thanks for the help
 
To create a directory, use the Dir function.
Look up vba help for Dir.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Uhl said:
I use a field called "Ordner" as Hyperlink with data e.g. "C:\Customers".
I also use a field named "Lastname" as Text with data e.g. "Miller".

Now I want to create a directory Miller in C:\custmers

Result: C:\customers\Miller

Thanks for the help
Click to expand...

MkDir "C:\customers\" & Me.Lastname

If you ever want to create an entire directory structure in one go, try
this:

http://www.smccall.demon.co.uk/Strings.htm#CreatePath
 
Back
Top