Filesearch in Access 2007 Beta

[Tim G.]

Hi all,

Some code that I wrote in ACC2003 using the FileSearch object does not work
in the 2007 Beta. I have read that the new object model has "hidden" this
object (though I'm not sure what that means precisely). At any rate the
FileSearch object has ceased to function.

Is anyone aware of this issue and/or a work-around to using the FileSearch
object to getting a list of file names from a specified path?

Many thanks,

Tim

 

[Tom Wickerath]

Hi Tim,

For whatever reason (?), Microsoft choose to remove FileSearch from Access
2007. If you are searching just one folder, you should be able to use the DIR
function. If you are searching a specified path and all sub-directories, then
you'll likely need to substitute an API method. So far, I know of only one
document, written by Access MVP Doug Steele, that shows how to do this, but
it is not free. I think that you can purchase just the given issue, without
having to have a full subscription:

http://advisor.com/doc/16279

You might try searching for information on the FindFirstFile, FindNextFile
and FindClose API functions, but I suspect that your time will be better
spent by simply contacting Access Advisor and purchasing this issue.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Tim G.]

Thanks for the helpful information. I'm sorry to lose FileSearch, but thanks
to you I can work around it.

Tim

 

[Tom Wickerath]

Hi Tim,

The API-based method is much faster versus using FileSearch, so you may not
end up being so sorry that you were forced to find an alternative.

Good Luck with your project.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Tom Wickerath]

Update regarding the Access Advisor article:
I have just been informed that the publisher has changed the status of this
article from subscription only to free for anyone to view!

http://advisor.com/doc/16279


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________