[AccessD] OT - file search results save

Thanks Jim

I would greatly appreciate it. Whenever you get to it. 

Thanks



> -----Original Message-----
> From: Jim DeMarco [mailto:Jdemarco at hudsonhealthplan.org]
> Sent: Friday, February 13, 2004 12:49 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] OT - file search results save
> 
> 
> Patricia,
> 
> I don't have it handy but I put together an utility app that 
> loops through our network and adds this information to an 
> Access table (A97).  Put simply use the Dir command in VBA 
> and then use ADO or DAO to save any found item to the table.  
> If you like I can look for it but it's been quite a while 
> since we've run it and may take some time to find.
> 
> Jim DeMarco
> Director Product Development
> Hudson Health Plan
> 
> 
> -----Original Message-----
> From: O'Connor, Patricia [mailto:Patricia.O'Connor at DFA.STATE.NY.US]
> Sent: Friday, February 13, 2004 12:33 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] OT - file search results save
> 
> 
> I did a search of one of our server drives for all *.MDB 
> using the Windows
> 2000 search.  Give name of file, directory, size, modify 
> date.  Great just
> what I want, except I can not figure out how to get the 
> results into a file
> - word, text, excel 
> 
> If I do save results, it puts it into a file but all that 
> seems to do is
> save the search string.  
> 
> 
> Does anyone know how I can save the listing or have a utility 
> that will
> allow me to save this in a file. It is probably something 
> simple but I am
> just getting no where.
> 
> Thanks
> Patti
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
>  
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>