Pausing a procedure

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Hi,

I have db that crates some files, then runs a shell to
zip up the files using the Winzip command utility and
then use the Kill command to delete the unzipped files
once zipped as a tidy up.

The issues is that the Kill command kicks in before the
zipping is finished and I would like to try and delay the
final step in the procedure. Can you adivse of the best
way to do this.
Can I use TimerInterval or something to do this.
Ideally I would like to delay the program for around 5
seconds to allow winzip to finish it's task before
continuing with the Kill command.

Hope this is enough information.

Andy
 
Andy said:
Hi,

I have db that crates some files, then runs a shell to
zip up the files using the Winzip command utility and
then use the Kill command to delete the unzipped files
once zipped as a tidy up.

The issues is that the Kill command kicks in before the
zipping is finished and I would like to try and delay the
final step in the procedure. Can you adivse of the best
way to do this.
Can I use TimerInterval or something to do this.
Ideally I would like to delay the program for around 5
seconds to allow winzip to finish it's task before
continuing with the Kill command.

Hope this is enough information.
Click to expand...

You may be able to use the ShellWait function posted here ...

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

.... to wait until the shelled program finishes. If that doesn't work
and you need to wait for a preset interval, you can call the Sleep API
to do it, as directed here:

http://www.mvps.org/access/api/api0021.htm
 
Back
Top