Autocreate folders on new record entry.

[slames]

Is it possible to autocreate a folder and subfolders after update of certain criteria, using variables from a form to name the folders? If so can anyone give me some pointers please.
Thanks
Steph

 

[PaulTEG]

use mkdir

chdir to the correct starting point, and then MkDir Forms!MyFrm.var.value

Hopr this helps

 

[PBAPaul]

If you use MkDir and the directory is already there, then you get a File Accesss error (error 75, if I remember correctly).

Use the technique below to prevent an error occurring.

On Error Resume Next
ChDir DataDir
If Err = 76 Then MkDir MyNewDir
Err = 0

Paul

 

[slames]

Thanks everyone, have got this working now. Cheers.