Results 1 to 3 of 3
  1. #1
    alfrval is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2015
    Posts
    1

    Question list files in a directory

    i am new to access.
    can someone tell/show me how to create a list of files in a directory outside of the access program


    C:\Users\al\Desktop\MSACCESS PROGRAM is the location

  2. #2
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    You will need a bit of VBA code, and you will need to use the Dir function.

    Check the VBA Help facility for how to use Dir.

    What do you need to do with the resulting file list?

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,518
    alfrval,

    I have the same question as John --What are you planning to do with the file list?

    Here is a link that may give you some ideas.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. list all files in a directory
    By snipe in forum Programming
    Replies: 5
    Last Post: 01-21-2014, 12:18 PM
  2. Replies: 1
    Last Post: 01-17-2014, 09:51 AM
  3. Replies: 1
    Last Post: 11-07-2013, 11:15 AM
  4. Replies: 22
    Last Post: 01-28-2013, 02:55 PM
  5. Replies: 6
    Last Post: 06-15-2011, 04:38 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums