[AccessD] Using WinZip With Access

A little trickier, but if you want to embed zip functionality in your
program without requiring the user to purchase any additional software,
check this out:
http://www.vbaccelerator.com/home/VB/Code/Libraries/Compression/Zipping_File
s/article.asp

And regardless of what you choose to do, register WinZip ;-)


-----Original Message-----
From: DWUTKA at marlow.com [mailto:DWUTKA at marlow.com]
Sent: Tuesday, April 20, 2004 11:36 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Using WinZip With Access

Winzip is only like $25.  I had the same issue, and decided that spending
the few bucks to get a registered copy of Winzip was a better 'deal' then
wasting time trying to code around the unregistered limitation.

Turns out there is a LOT more available in the registered version of Winzip
too.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
paul.hartland at fsmail.net
Sent: Tuesday, April 20, 2004 10:40 AM
To: accessd
Subject: [AccessD] Using WinZip With Access


To all,
 
Thanks for everybody's help on this I now know what the problem is.  We are
using an Evaluation copy of Winzip, if I set the focus of the Shell command
below to vbMaximizedFocus:
 
strCommand = "C:\Program Files\Winzip\Wzzip.exe " & wzFinal & " " &
strShiftData & " " & strDownTime & vbCrLf
            wzFiles = Shell(strCommand, vbMaximizedFocus)
 
A message appears in the window with press any key to continue, and if I
press any key it works perfect.  Is there anyway I can include the keypress
into the Shell Command.  If I can get this to work automatically then I
should be able to convince the powers that be to invest in the fully
registered version.  
 
Thanks again for everyone's help on this
 
Paul Hartland
Database Designer/Developer
Join the UK's number one for the internet 
www.freeserve.com/time
--

--------------------------------------------------------------------------------------------------------------------
The information in this email may contain confidential information that 
is legally privileged. The information is only for the use of the intended 
recipient(s) named above. If you are not the intended recipient(s), you 
are hereby notified that any disclosure, copying, distribution, or the taking 
of any action in regard to the content of this email is strictly prohibited.  If 
transmission is incorrect, unclear, or incomplete, please notify the sender 
immediately. The authorized recipient(s) of this information is/are prohibited 
from disclosing this information to any other party and is/are required to 
destroy the information after its stated need has been fulfilled.

Any views expressed in this message are those of the individual
sender, except where the sender specifies and with authority,
states them to be the views of Tappe Construction Co.

This footer also confirms that this email message has been scanned
for the presence of computer viruses.Scanning of this message and
addition of this footer is performed by SurfControl E-mail Filter software
in conjunction with virus detection software.