Who got the answer for this question??? 1

[Guest_imported]

This is the code that I'm using and my question is How can I make a "Wait" between the time the computer compress and the time that he create the EXE file?


'Copy the original database to my C drive
SourceFile = "R:\Redax PO\Redabck_be.mdb"
Destination = "C:\Temp\Redabck_be.mdb"
FileCopy SourceFile, Destination

'Launch Winzip ans zip the file
Call Shell("C:\Program Files\winzip\Winzip32 -min -a c:\temp\redabck_be.zip C:\Temp\Redabck_be.mdb&quot
SendKeys "{^} & A "

'Make an EXE file with the Db zip
Call Shell("C:\Pkware\Zip2exe.exe c:\temp\redabck_be.zip&quot

 

[DougP]

how long do you need to wait?

dim x as double
do while x <> 100000
x=x+1
loop

the faster you machine the larger the number

Also
you can also set a variable to True and then when a process is finished set it to false

MyVar=true
Gosub xxxx
Do while MyVar=True
Loop

finish it here

exit sub
xxxx:
do something here


MyVar = False
return

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[jzolnoski]

The proper way to complete this task is to use something other than the shell command.
Microsoft has explained this quite well (with example code) in the following knowledge base article.

http://support.microsoft.com/support/kb/articles/q178/1/16.asp

I have used this code for exactly the same thing (create a zip then convert to exe) and it works perfect.

 

[tombirch]

You can use the shellwait function found on this address:

http://www.mvps.org/access/api/api0004.htm

This will wait until the shell program has finished before the code continues.



TomBirch