[AccessD] Unzip Files Part II

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.