Prev: Calendar Form
Next: Drag and Drop from Outlook
From: Uhl on 27 Jan 2010 04:13
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
From: Jeanette Cunningham on 27 Jan 2010 05:01
To create a directory, use the Dir function.
Look up vba help for Dir.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Uhl" <octavee(a)gmx.net> wrote in message
news:uGlfCEznKHA.3664(a)TK2MSFTNGP04.phx.gbl...
>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


From: Stuart McCall on 27 Jan 2010 05:51
"Uhl" <octavee(a)gmx.net> wrote in message
news:uGlfCEznKHA.3664(a)TK2MSFTNGP04.phx.gbl...
>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


 | 
Pages: 1
Prev: Calendar Form
Next: Drag and Drop from Outlook