Group:  Microsoft Access ยป microsoft.public.access
Thread: Filesearch in Access 2007 Beta

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Filesearch in Access 2007 Beta
Tim G. 30.09.2006 23:30:01
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
RE: Filesearch in Access 2007 Beta
Tom Wickerath 30.09.2006 23:51:01
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." wrote:

[Quoted Text]
> 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
RE: Filesearch in Access 2007 Beta
Tim G. 01.10.2006 01:49:01
Thanks for the helpful information. I'm sorry to lose FileSearch, but thanks
to you I can work around it.

Tim

"Tom Wickerath" wrote:

[Quoted Text]
> 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." wrote:
>
> > 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
RE: Filesearch in Access 2007 Beta
Tom Wickerath 01.10.2006 02:04:01
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
__________________________________________

"Tim G." wrote:

[Quoted Text]
> Thanks for the helpful information. I'm sorry to lose FileSearch, but thanks
> to you I can work around it.
>
> Tim

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net