[AccessD] Unzip Files Part II

DWUTKA at marlow.com DWUTKA at marlow.com
Mon May 2 22:35:16 CDT 2005


That is definitely your problem then. Dir can be called again to return more
files found by an initial 'search', however, if Dir is called subsequently,
then it will stop it's 'search'. 

I believe there is a function called FileExists if you just want to
determine if a file exists..that shouldn't affect Dir()

Drew

-----Original Message-----
From: Mark A Matte [mailto:markamatte at hotmail.com]
Sent: Monday, May 02, 2005 3:19 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Unzip Files Part II


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


-- 
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