[AccessD] AccessD Digest, Vol 100, Issue 26

To see if it exists:

Public Function udf_FolderExists(strPath As String) As Boolean
     On Error Resume Next
     udf_FolderExists = ((GetAttr(strPath) And vbDirectory) = vbDirectory)
End Function



At 12:03 AM 6/24/2011, you wrote:
>Date: Fri, 24 Jun 2011 00:02:52 -0400
>From: Arthur Fuller <fuller.artful at gmail.com>
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Subject: [AccessD] Does a directory exist?
>Message-ID: <BANLkTinbimBP8tnqiFZFHU0jDf7YPEUGdQ at mail.gmail.com>
>Content-Type: text/plain; charset=ISO-8859-1
>
>I've been playing around with the Dir() function but I can't figure out how
>to determine whether a directory exists, so I can create it if it doesn't.
>Followup question: can I create a directory called "C:\major\minor" if
>"C:\major" doesn't exist, or do I have to create "C:\major" first and then
>create "C:\major\minor"?
>
>TIA,
>Arthur

Robert L. Stewart
www.WeBeDb.com
www.DBGUIDesign.com
www.RLStewartPhotography.com