 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / May 2007Filesearch object
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. 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/  SignatureBest regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com >I recently moved my file designed in Access 2003 into Access 2007 and now >the [quoted text clipped - 5 lines] > added > in to the references, but it doesn't seem to work. 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. > Hi, > there is no filesearch in Access 2007 anymore, you can use API instead, like [quoted text clipped - 13 lines] > > added > > in to the references, but it doesn't seem to work. To list files in a particular directory - you can use VBA Dir function SignatureBest regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com > thanks alot. but would the api be able to provide a list of files in a > particularly directory? seems this function call from the [quoted text clipped - 22 lines] >> > added >> > in to the references, but it doesn't seem to work. 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... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.