Results 1 to 4 of 4
  1. #1
    bscottj48 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    3

    Search and How to display the files in a directory


    We want to create a Form for searching. We want the results to return the names of files (linked if possible), from a specific folder location on a "Shared" drive.

    For example: We have Product X. We want to search for and need to "see" documentation for Product X concerning Admin Procedures, or Reference Materials, or User Manual.

    Is this doable?

    Please advise. Thanks.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Edit: Understand that this code here will DELETE files
    Code:
    objFile.Delete True
    If you reference the Microsoft Scripting Runtime you can use code like this ...
    https://www.accessforums.net/access/...tml#post274051

  3. #3
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,803
    Using the file dialog box might be another option. You could select and manage all the files (open, delete, copy, move) that matched your needs by setting the multi select property to true. Not only would you not have to create/maintain/evaluate links to the files, you would be able to visually make near match comparisons. If someone mis-typed the file name, it would be obvious, but you may not be able to deal with all the possible spelling variations through code.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    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. list files in a directory
    By alfrval in forum Access
    Replies: 2
    Last Post: 02-25-2015, 12:46 PM
  2. list all files in a directory
    By snipe in forum Programming
    Replies: 5
    Last Post: 01-21-2014, 12:18 PM
  3. Replies: 1
    Last Post: 01-17-2014, 09:51 AM
  4. Replies: 1
    Last Post: 11-07-2013, 11:15 AM
  5. Replies: 6
    Last Post: 06-15-2011, 04:38 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