Pausing a procedure

[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

 

[Dirk Goldgar]

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.

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

 

[Andy]

Thanks I'll try that.
Andy

-----Original Message-----


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

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.