create directory from a form

[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

 

[Jeanette Cunningham]

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


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Stuart McCall]

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

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