Filesearch object

[Steven Cheng]

I recently moved my file designed in Access 2003 into Access 2007 and now the
application.filesearch object, which allowed for the database to retrieve a
list of files in a particular folder, isn't working. i tried to follow the
help instructions and have the Microsoft office object library (12.0) added
in to the references, but it doesn't seem to work.

 

[Alex Dybenko]

Hi,
there is no filesearch in Access 2007 anymore, you can use API instead, like
here:
http://www.mvps.org/access/api/api0006.htm

more samples are here:
http://www.freevbcode.com/

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Steven Cheng]

thanks alot. but would the api be able to provide a list of files in a
particularly directory? seems this function call from the
http://www.mvps.org/accesss/api/api0006.htm would only allow for search for a
particular file and return its path.

 

[Alex Dybenko]

To list files in a particular directory - you can use VBA Dir function

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Simon T-L]

Not wishing to write something which was working perfectly well under
Access2000, can I use an old dll to reinstate this under Access 2007 - and
which one do I need? Many thanks...