G
Guest
I am running a third party libarary. (Redemption).
The program launches redemption just fine. the problem is that the
Redemption is telling Access that it is done right after it is lauched.
Redemption attaches a file to fourty different emails.
A lot of the emails don't have attachments.
It is my beliefe that Access is renaming the Attachment file before
Redemption has a chance to finish its work. I would like to force Access to
wait for the function that launches Redemption to finish. The following code
is what I came up with but I am not sure it works the way I think it does.
Function WaitForMe(StrProgramName As String)
Rem Wait for a program to finish.
Do While SysCmd(acSysCmdGetObjectState, acModule, "ISSMEMO")
DoEvents
Loop
End Function
Do you have a better way of doing this?
Scott Burke
P.S. The programmers at Redemption don't think this is the issue but the
program works fine on a slow computer. The faster computers are the ones
with the problems.
The program launches redemption just fine. the problem is that the
Redemption is telling Access that it is done right after it is lauched.
Redemption attaches a file to fourty different emails.
A lot of the emails don't have attachments.
It is my beliefe that Access is renaming the Attachment file before
Redemption has a chance to finish its work. I would like to force Access to
wait for the function that launches Redemption to finish. The following code
is what I came up with but I am not sure it works the way I think it does.
Function WaitForMe(StrProgramName As String)
Rem Wait for a program to finish.
Do While SysCmd(acSysCmdGetObjectState, acModule, "ISSMEMO")
DoEvents
Loop
End Function
Do you have a better way of doing this?
Scott Burke
P.S. The programmers at Redemption don't think this is the issue but the
program works fine on a slow computer. The faster computers are the ones
with the problems.