Does a folder exist

[Beady]

Hi,

I've got an Access 97 piece that imports text files, copies and moves the used files and several other things.

I've now been asked to enable it to create a fairly complex folder structure.

I've done that, but I'd like to be able to issue a warning if the root folder already exists, can someone please show me how to check if a particular folder exists (I don't particularly care if its full or empty).

 

[GaryPanic]

check make directory in the samples - its all their as well as the check to see if directory exists

 

[allan57]

check out the 'Dir function' under vba help

 

[Beady]

Excellent answers, I was using dir, but I'd missed the vbDirectory attribute.

Many thanks.