[AccessD] A2203: Determine if a folder exists

Darren DICK d.dick at uws.edu.au
Mon Mar 21 20:00:57 CST 2005


Hello all
This should be simple but it's causing me pain
I have a folder (It does exist)
C:\SomeFolder\SomeSubFolder\TheDestination

If I type the following code and 'run' it

If IsNull(Dir(Me.PathToDownloadTo)) Or Dir(Me.PathToDownloadTo) = "" Then
        MsgBox "Folder Doesn't Exist"
    Else
        MsgBox "Folder exists"
    End If

It still tells me the folder doesn't exist even though it does

What is a 'proper' way to tell if a folder exists

Many thanks in advance

Darren





More information about the AccessD mailing list