how to pause code without using msgbox?

Hello all,

Many thanks to all who help me out here. Anway, I am
updating tables in an Access mdb from my app and then
copying files from a server to various workstations. What
happens is that the code will get to a FileCopy command
before various tables have finished updating where the
FileCopy command uses data from the tables. I have been
using msgbox "Pause" to stop code execution, but this is
not seamless. I believe my solution lies here:

Set Shl = CreateObject("WScript.Shell")

But what comes after Shl....?

Any suggestions how to pause code execution (without
msgbox) greatly appreciated.

Thanks in advance.
Rich

Rich
Mon Jan 19 17:11:28 CST 2004

I left out another condition to my problem: I am using an
hta file. Therefore WScript.exe is not supported I
discovered, so WScript.Sleep 100 won't work. Is there a
workaround for this?


>-----Original Message-----
>Hello all,
>
>Many thanks to all who help me out here. Anway, I am
>updating tables in an Access mdb from my app and then
>copying files from a server to various workstations.
What
>happens is that the code will get to a FileCopy command
>before various tables have finished updating where the
>FileCopy command uses data from the tables. I have been
>using msgbox "Pause" to stop code execution, but this is
>not seamless. I believe my solution lies here:
>
>Set Shl = CreateObject("WScript.Shell")
>
>But what comes after Shl....?
>
>Any suggestions how to pause code execution (without
>msgbox) greatly appreciated.
>
>Thanks in advance.
>Rich
>.
>

Rich
Mon Jan 19 18:13:18 CST 2004

Well, the only workaround I have come up with is to run a
loop where I read 100 rows from a table, exit the loop
move onto the next procedure. If anyone has a better
solution for pausing code, please share.

>-----Original Message-----
>Hello all,
>
>Many thanks to all who help me out here. Anway, I am
>updating tables in an Access mdb from my app and then
>copying files from a server to various workstations.
What
>happens is that the code will get to a FileCopy command
>before various tables have finished updating where the
>FileCopy command uses data from the tables. I have been
>using msgbox "Pause" to stop code execution, but this is
>not seamless. I believe my solution lies here:
>
>Set Shl = CreateObject("WScript.Shell")
>
>But what comes after Shl....?
>
>Any suggestions how to pause code execution (without
>msgbox) greatly appreciated.
>
>Thanks in advance.
>Rich
>.
>

Joe
Tue Jan 20 04:09:36 CST 2004

ScriptX from Meadroid, free part has wait method.

--
Joe
"Rich" <anonymous@discussions.microsoft.com> wrote in message
news:0c4301c3deea$348fd1e0$a501280a@phx.gbl...
> Well, the only workaround I have come up with is to run a
> loop where I read 100 rows from a table, exit the loop
> move onto the next procedure. If anyone has a better
> solution for pausing code, please share.
>
> >-----Original Message-----
> >Hello all,
> >
> >Many thanks to all who help me out here. Anway, I am
> >updating tables in an Access mdb from my app and then
> >copying files from a server to various workstations.
> What
> >happens is that the code will get to a FileCopy command
> >before various tables have finished updating where the
> >FileCopy command uses data from the tables. I have been
> >using msgbox "Pause" to stop code execution, but this is
> >not seamless. I believe my solution lies here:
> >
> >Set Shl = CreateObject("WScript.Shell")
> >
> >But what comes after Shl....?
> >
> >Any suggestions how to pause code execution (without
> >msgbox) greatly appreciated.
> >
> >Thanks in advance.
> >Rich
> >.
> >

Joe
Tue Jan 20 08:17:00 CST 2004

Hi,

If you can add an ActiveX, Hiddensoft's AutoItX freeware scripting add-on
has its own Sleep method that's identical to WScript, plus a lot of other
useful items.


http://www.hiddensoft.com/AutoIt/


Joe Earnest



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.564 / Virus Database: 356 - Release Date: 01-19-04

Rich
Tue Jan 20 11:49:35 CST 2004

Thanks all for these suggestions and for the link. My
goal, however, is to use apps which don't require any
installing of software on my part. For example, the apps
that I need to copy the latest versions of on each
workstation are just Excel apps. My boss wants me to keep
the latest and greated version on each workstation without
having to install anything more than Mdac. So for the
meantime, I am simulating sleep by reading a bunch of rows
from a junk table in Access. Of course, the hassel here
is that I now have a bunch of do loops all over the
place. Oh well.

Rich

>-----Original Message-----
>ScriptX from Meadroid, free part has wait method.
>
>--
>Joe
>"Rich" <anonymous@discussions.microsoft.com> wrote in
message
>news:0c4301c3deea$348fd1e0$a501280a@phx.gbl...
>> Well, the only workaround I have come up with is to run
a
>> loop where I read 100 rows from a table, exit the loop
>> move onto the next procedure. If anyone has a better
>> solution for pausing code, please share.
>>
>> >-----Original Message-----
>> >Hello all,
>> >
>> >Many thanks to all who help me out here. Anway, I am
>> >updating tables in an Access mdb from my app and then
>> >copying files from a server to various workstations.
>> What
>> >happens is that the code will get to a FileCopy command
>> >before various tables have finished updating where the
>> >FileCopy command uses data from the tables. I have
been
>> >using msgbox "Pause" to stop code execution, but this
is
>> >not seamless. I believe my solution lies here:
>> >
>> >Set Shl = CreateObject("WScript.Shell")
>> >
>> >But what comes after Shl....?
>> >
>> >Any suggestions how to pause code execution (without
>> >msgbox) greatly appreciated.
>> >
>> >Thanks in advance.
>> >Rich
>> >.
>> >
>
>
>.
>

JR
Thu Jan 22 11:22:17 CST 2004

start=now
'the abs is needed on midnight
do while abs(start-now)<timeserial("1:2:3") 'use your time
Loop

--
Met vriendelijke groeten.
Jan
"Joe Fawcett" <joefawcett@hotmail.com> schreef in bericht
news:%23LByt3z3DHA.3416@tk2msftngp13.phx.gbl...
> ScriptX from Meadroid, free part has wait method.
>
> --
> Joe
> "Rich" <anonymous@discussions.microsoft.com> wrote in message
> news:0c4301c3deea$348fd1e0$a501280a@phx.gbl...
> > Well, the only workaround I have come up with is to run a
> > loop where I read 100 rows from a table, exit the loop
> > move onto the next procedure. If anyone has a better
> > solution for pausing code, please share.
> >
> > >-----Original Message-----
> > >Hello all,
> > >
> > >Many thanks to all who help me out here. Anway, I am
> > >updating tables in an Access mdb from my app and then
> > >copying files from a server to various workstations.
> > What
> > >happens is that the code will get to a FileCopy command
> > >before various tables have finished updating where the
> > >FileCopy command uses data from the tables. I have been
> > >using msgbox "Pause" to stop code execution, but this is
> > >not seamless. I believe my solution lies here:
> > >
> > >Set Shl = CreateObject("WScript.Shell")
> > >
> > >But what comes after Shl....?
> > >
> > >Any suggestions how to pause code execution (without
> > >msgbox) greatly appreciated.
> > >
> > >Thanks in advance.
> > >Rich
> > >.
> > >
>
>

rboger
Sat Jan 31 13:40:01 CST 2004

Rich,

I'm rather new to VbScript, but you should be able to use

Wscript.Sleep 60000

60,000 is in miliseconds where 1,000 miliseconds = 1 second. Yo
wouldn't need to use a shell at all using this method as well.

Hope that helps,
Rob Boger


Rich wrote:
> Any suggestions how to pause code execution (without
> msgbox) greatly appreciated.
>
-
rboge
-----------------------------------------------------------------------
posted via www.WebFrustration.com