Microsoft KB Archive/171193

= ACC97: Sample Procedure to Find the Location(s) of a File =

Article ID: 171193

Article Last Modified on 1/20/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q171193



Advanced: Requires expert coding, interoperability, and multiuser skills.



SUMMARY
This article describes how to create a sample user-defined function that uses the FileSearch object contained in the Application object to locate a file on a particular drive.

This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information about Visual Basic for Applications, please refer to the "Building Applications with Microsoft Access 97" manual.



MORE INFORMATION
The LocateFile function takes the file that you are looking for as a string argument and returns all locations of that file. To create the function, follow these steps:

 Open the sample database Northwind.mdb.  Create a module and type the following line in the Declarations section if it is not already there:

     Option Explicit   Type the following procedure:

Function LocateFile(strFileName as String) Dim vItem As Variant With Application.FileSearch .FileName = strFileName .LookIn = "c:\" .SearchSubFolders = True .Execute For Each vItem In .FoundFiles Debug.Print vItem Next vItem End With End Function  To test this function, type the following line in the Debug window, and then press ENTER:

?LocateFile("northwind.mdb")

Note that all locations of Northwind.mdb are printed in the Debug window.

