Mark A Matte
markamatte at hotmail.com
Mon May 2 15:19:02 CDT 2005
The code is on a machine at home...but I know there is a DIR call in the second function to see if the winzip.exe is there. I modify when I get home. On your other email...I will also look at the winzip command line. Thanks, Mark A. Matte >From: DWUTKA at marlow.com >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: accessd at databaseadvisors.com >Subject: RE: [AccessD] Unzip Files Part II >Date: Mon, 2 May 2005 13:49:08 -0500 > >Post your code. Guessing in the blind, sounds like Function 2 is using the >Dir function (maybe checking to see if the file exists before >unzipping....), because that would goof secondary calls to Dir in your >first >function. > >Drew > >-----Original Message----- >From: Mark A Matte [mailto:markamatte at hotmail.com] >Sent: Monday, May 02, 2005 1:30 PM >To: accessd at databaseadvisors.com >Subject: RE: [AccessD] Unzip Files Part II > > >Hello All, > >I gave up on a command line to use XP's unzip...I bought WINZIP and wrote 2 >functions: >1. uses DIR to get all files in a certain folder and loop through until >the > >end of directory...(works fine) >2. shells to winzip and extracts needed files to determined >folder...(works > >fine) > >Then I called function 2 from function 1 as it looped through each >file...and after the first file was unzipped...the loop determined it was >at > >the end of of the directory. > >Any ideas why this happens? > >Unless there are any ideas for a better approach/workaround...I plan on >movig the DIR inside the loop...and then deleting the .zip file after its >extracted...then add an IF statement that ends the loop if the DIR returns >nothing. > >Any thoughts/suggestions? > >Thanks, > >Mark A. Matte > > > >From: DWUTKA at marlow.com > >Reply-To: Access Developers discussion and problem > >solving<accessd at databaseadvisors.com> > >To: accessd at databaseadvisors.com > >Subject: RE: [AccessD] Unzip Files > >Date: Thu, 28 Apr 2005 11:14:24 -0500 > > > >True. I copy and pasted the code years ago, when I built the original > >program I am rebuilding. Nowadays, I tend to make my own 'utility' > >modules, > >just for the fun of it.... > > > >Drew > > > >-----Original Message----- > >From: Gustav Brock [mailto:Gustav at cactus.dk] > >Sent: Thursday, April 28, 2005 10:24 AM > >To: accessd at databaseadvisors.com > >Subject: RE: [AccessD] Unzip Files > > > > > >Hi Drew > > > >The major source for these generic functions is the official API > >specifications and examples. > >I've seen so many variations on these and it is impossible to tell who > >included which comments. > > > >/gustav > > > > >>> DWUTKA at marlow.com 04/28 4:59 pm >>> > >I don't know, I rarely use other people's code now, and so I prefer not > >to > >post someone else's work. You didn't include the comments I have in > >my > >module, which denote the original author. > > > >Drew > > > >-----Original Message----- > >From: Gustav Brock [mailto:Gustav at cactus.dk] > >Sent: Thursday, April 28, 2005 9:49 AM > >To: accessd at databaseadvisors.com > >Subject: RE: [AccessD] Unzip Files > > > > > >Hi Drew > > > >Since when have you turned into chicken mode? > > > >-- > >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