What replaces Application.Filesearch in Access 2007?

[Kamil Dursun]

Hi again,

I am stuck on this subject. I want to make a list of all files in a folder
and its sub-folders.

Previously I used Application.FileSearch and it gave me the whole list.
Apparently this is no more a part of Access 2007.

Can anybody give me a hint how to list the files in my folder and its
sub-folders?

Thanks in advance
Kamil

 

['69 Camaro]

Hi, Kamil.

I am stuck on this subject. I want to make a list of all files in a folder
and its sub-folders.

Previously I used Application.FileSearch and it gave me the whole list.
Apparently this is no more a part of Access 2007.

Use Allen Browne's "List files recursively" tip:

http://allenbrowne.com/ser-59.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Kamil Dursun]

Thank you '69 Camaro. This seems to do the job.

Kamil

 

['69 Camaro]

You're welcome. Glad it helped.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.