Code to make new folder

[Studenn]

Hi again, still developing my database. Have made lots of progress thanks to help from this forum. Can anyone help with this problem. The database amongst other things is a client record. When setting up a new client I use a seperate form. I would like to code the form to confirm that I wish to save details that have been entered at the same time I would like to create a folder with the same name as the [clientname] to store correspondence etc this to be all at the click of a save command button.

Any help would be greatly appreciated.

Thanks.

 

[pbaldy]

Look at the MkDir statement in VBA.

 

[ChrisO]

G’day Paul and Studenn

There are a few methods in this thread that should help.

Regards,
Chris.

 

[Studenn]

Thanks - Can't get it to work. Using this code. I want to be able to open a folder with same name as ClientName on the open form.

On Click

MkDir "C:\TestFolder\Me![ClientName]"

Help Please

Stuart

 

[mresann]

Try

MkDir "C:\TestFolder\" & Me![ClientName]

You have to combine the literal string with the variable (or record), not include the variable inside the literal string.

 

[Studenn]

Thanks. Thats cracked it