Need to check if dir exists and if not Create in with a variable.

[aunixguru]

I have a project form. On it is a project name.

I need to check to see that &quot;\\server\<projectname>&quot; does not exists before trying to create it.

2nd problem.. Creating it.

I have had no luck creating anything with the use of a variable.

I can do a mkdir &quot;\\server\Access project&quot; (works)
I cannot do this: mkdir &quot;\\server\&quot; & me![projectname]

Can someone explain how to use a variable in this instance?

mkdir syntax: mkdir &quot;<name&quot;

Thanks

 

[CPUburn]

Hi there:

check if dir exists:

dim test as integer

test = len(dir(&quot;\\server\<projectname>&quot; ))
if test = 0 then
'' directory doesn't exist
'' mkdir ... --> should work like you described !!
'' --> if you want to be sure you have the
'' right syntax, test with:
str_test = &quot;\\server\&quot; & me![projectname]
msgbox str_test

mkdir str_test
end if