Results 1 to 2 of 2
  1. #1
    dunc723 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Posts
    28

    Replacing the FileSearch Property

    My current project is to compare the contents of two folders (FolderA and FolderB), which have multiple levels of subfolders; if there is an exact duplicate file (FolderA\SubA\Sub1\File1.ext and FolderB\SubA\Sub1\File1.ext with the same modified time), flag it in a table (or perhaps take other actions).



    I used to use Application.FileSearch to get a listing of files, including the full path and filename, and put them into a recordset. It would optionally search all subfolders. How to do that in Access 2010 without FileSearch? I've researched the Dir function, but a quick trial showed it does not search subfolders - it appears you have to keep drilling down by searching for folders and building path strings. Is there any other function or procedure?

    Thanks for any advice!

    Windows 7, Access 2010

    Peter

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replacing one value for another
    By Richiebob in forum Programming
    Replies: 10
    Last Post: 05-06-2013, 11:33 AM
  2. Replacing space with dot
    By JeroenMioch in forum Programming
    Replies: 15
    Last Post: 10-22-2012, 07:09 AM
  3. FileSearch LastModified Type Mismatch
    By CevinMoses in forum Forms
    Replies: 3
    Last Post: 10-05-2010, 04:16 PM
  4. FileSearch object not finding files
    By tdalber in forum Programming
    Replies: 3
    Last Post: 05-14-2009, 10:16 AM
  5. Replacing Null with 0
    By gilagain1 in forum Queries
    Replies: 5
    Last Post: 04-23-2009, 01:47 PM

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