F
Fredrated
Subject: Pause code execution: how? + something wierd
(I place the subject here because I have never been able to see the full
subject of posts to this forum and that is lame to the max in my opinion)
I posted this question once today, under the subject "Pause code execution:
how?"
The wierd thing is, it does not show up as a question when I sign on to this
discussion, yet I received an email perporting to notify me of a reply!
Supposedly the reply is at
http://www.microsoft.com/wn3/aspx/n...ovba&mid=bd3138b3-28a9-4f56-bb11-ad018752d538
yet when I enter this into the address bar it just takes me to the beginning
of this thread with no sign of my post!!!???!!!
Oh well, I will try again, if others can see the post and reply I can't see,
please forgive me for posting again.
I need to pause code execution in a VBA object. I have a 3rd party email
object (ansmpt, you may have heard of it) and it has worked fine for several
years. For some reason recently we have had a problem with our mail server,
and the email object now intermitently gets no reply from our mail server
when it attempts to send an email from within Access XP. Our sys admin has
asked me to add code which retries to send an email after a 10 second pause
if the first attempt results in no reply from our mail server. So the
question is, how do I add a pause to the code execution?
This is in a process that automatically runs nightly, started by Windows
task scheduler. The access app has a startup form, and this form
instantiates and passes control to an object which does all the work. I
would prefer a way to pause execution without refering to the startup form
timer, but will use the startup form if necessary.
So, how can I pause code execution for 10 seconds, with or without accessing
the startup form timer?
Thanks in advance for any help you can give. I hope this attempt to post
this question works.
Fred
(I place the subject here because I have never been able to see the full
subject of posts to this forum and that is lame to the max in my opinion)
I posted this question once today, under the subject "Pause code execution:
how?"
The wierd thing is, it does not show up as a question when I sign on to this
discussion, yet I received an email perporting to notify me of a reply!
Supposedly the reply is at
http://www.microsoft.com/wn3/aspx/n...ovba&mid=bd3138b3-28a9-4f56-bb11-ad018752d538
yet when I enter this into the address bar it just takes me to the beginning
of this thread with no sign of my post!!!???!!!
Oh well, I will try again, if others can see the post and reply I can't see,
please forgive me for posting again.
I need to pause code execution in a VBA object. I have a 3rd party email
object (ansmpt, you may have heard of it) and it has worked fine for several
years. For some reason recently we have had a problem with our mail server,
and the email object now intermitently gets no reply from our mail server
when it attempts to send an email from within Access XP. Our sys admin has
asked me to add code which retries to send an email after a 10 second pause
if the first attempt results in no reply from our mail server. So the
question is, how do I add a pause to the code execution?
This is in a process that automatically runs nightly, started by Windows
task scheduler. The access app has a startup form, and this form
instantiates and passes control to an object which does all the work. I
would prefer a way to pause execution without refering to the startup form
timer, but will use the startup form if necessary.
So, how can I pause code execution for 10 seconds, with or without accessing
the startup form timer?
Thanks in advance for any help you can give. I hope this attempt to post
this question works.
Fred