[AccessD] Find File in Folder and in Subfolder

Would you not need to know the beginning path of the where to start the
search?  If you are searching a whole drive, then you would just make the
starting path be "c:\" (or whatever drive it is on.  I would think that FSO
would do fine.

You could use DIR, but you would have to create a recursive function to
search the directory tree.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Monday, October 31, 2005 10:05 AM
To: AccessD
Subject: [AccessD] Find File in Folder and in Subfolder


I have a customer who wants their application to be able to find a file in a
folder or subfolder based on the entry in a text box.  The data entered is a
part number, and the file to be found is the drawing for that part.

However, their file structure is inconsistent.  I've looked at FSO, but that
requires that the path to a file be known.  DIR is a help with the
file/folders at the first level.  

Is there something that will search all the levels within a folder for a
specific file?

Thanks!
Dan Waters