[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
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com