Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2009

    Unanswered: Creating Folders from Access

    I work in a digital printing and graphics company. We store the artwork for each project in a folder structure based on the Order # and Product# (Ex. C:// Client Artwor/ Client Name/ ORD - 1502/COF - 5698/ Art From Client) which are generated in an access database. I would like to set it up so that either access or a VB module linked to access will automatically create this folder structure rather than doing it manually. If anyone can recommend an approach to this I would appreciate it.

    Mahalo, DAVE

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    It's been a while since I've dabbled in access, but I think the function you are looking for is called MkDir

    Should be lots of lovely info on it in the helpfiles. Hope this helps!
    Home | Blog

  3. #3
    Join Date
    Mar 2009
    Provided Answers: 15
    If you need more in-depth control over files and folders you could use the File System Object of the Scripting Library. See for instance:
    Have a nice day!

  4. #4
    Join Date
    Apr 2004
    Sydney Australia
    This will make a folder

    If Len(Dir("c:\YourFolderName", vbDirectory)) = 0 Then
    MkDir "c:\YourFolderName"

    End If

    You should be able to make that dynamic, that is, get the name of the folder from an Access text box.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts