[AccessD] Unzip Files Part II

Jim,

I don' think this would be the issue because when I step through the code 1 
line at a time...it is the same results.

Thanks,

Mark


>From: "Hale, Jim" <Jim.Hale at fleetpride.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: RE: [AccessD] Unzip Files Part II
>Date: Mon, 2 May 2005 13:48:43 -0500
>
>When you shell out and run a program Access doesn't wait but executes the
>next command. I suspect your loop is finished running before the program 
>you
>shelled to has done its thing. I found this out by creating a batch file to
>run via the shell and killing the file as the next command. Access killed
>the file before it could run. I solved it by making Access wait a few
>seconds.
>Jim Hale
>
>-----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
>
>***********************************************************************
>The information transmitted is intended solely for the individual or
>entity to which it is addressed and may contain confidential and/or
>privileged material. Any review, retransmission, dissemination or
>other use of or taking action in reliance upon this information by
>persons or entities other than the intended recipient is prohibited.
>If you have received this email in error please contact the sender and
>delete the material from any computer. As a recipient of this email,
>you are responsible for screening its contents and the contents of any
>attachments for the presence of viruses. No liability is accepted for
>any damages caused by any virus transmitted by this email.
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com