[AccessD] OT - file search results save

O'Connor, Patricia Patricia.O'Connor at DFA.STATE.NY.US
Fri Feb 13 13:15:51 CST 2004


Thanks Drew
Will give it a try this afternoon


Patti

> -----Original Message-----
> From: DWUTKA at marlow.com [mailto:DWUTKA at marlow.com]
> Sent: Friday, February 13, 2004 01:09 PM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] OT - file search results save
> 
> 
> I just sent you my 'Drive Mapper' utility (mind you, I wrote 
> it a while
> back....), which 'records' the files and folders in a drive, into a
> normalized structure.
> 
> drew
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of O'Connor,
> Patricia 
> Sent: Friday, February 13, 2004 11:55 AM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [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
> > 
> _______________________________________________
> 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
> 


More information about the AccessD mailing list