Creating Folders

[EAH002]

I have a really simple question.

I want to create a folder in a different directory. The name of the folder is a field in a form.

there must be a simple command to do this but i'm stumped.

any help is appreciated

cheers

Ewan

 

[JonH]

Try this Ewan,

MkDir ("C:\New Directory")

JonH.

 

[EAH002]

New Question

Thanks, thats great.

My next question is. I have a field in a form that i automatically want to be the same as a date feild but without the oblieks

Date field = 17/12/02

I want my "folder name" field to be 171202 as "/"s can't be used in file names.

I'm sure this is a pretty simple bit unortunately i don't have a VB book.

Thanks for any help

 

[JonH]

You can use MkDir("C:\" & Format(Date,"dd") & Format(Date,"mm") & Format(Date,"yy") & "filename and extension") to get the result you need.

JonH.