[AccessD] Using WinZip With Access

Hi Paul:

There is a way but it has been a long while since I have used it.

1. Create a file, say named return.txt and in notepad place one value, say
'1'.
2. Save file in an appropriate location, (and this is where it might become
complicated), run a program like, old DOS's debug, or a sector or hex editor
against the newly created file. In the editing mode change the value '1' or
now displayed as hex 31 to hex 13 (carriage return).
3. Save the file again and exit the hex editor.

Now you can use the following line of text when shelling to the command
prompt:

strCommand = "C:\Program Files\Winzip\Wzzip.exe " & wzFinal & " " &
strShiftData & " " & strDownTime & " < return.txt" & vbCrLf

wzFiles = Shell(strCommand, vbMaximizedFocus)

At the command prompt, the line should look something like:

C:\Program Files\Winzip\Wzzip.exe xxxx xxxx xxxx < return.txt

HTH
Jim

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