2 Questions

S

scadav

Hoping someone can help me out with these two questions:

#1 - Is there a way to call a function or procedure at a given time
interval? For example, I have a db that is used to create some tasks that
need to be accomplished by certain times. I would like to pop-up a warning
if the task is 30 minutes away.

#2 - I am outputting some reports to Excel utilizing excel automation.
Sometimes the output is rather large and I would like to cancel it in the
middle of the output. How do I go about having a cancel button stop a loop
from occurring in a procedure?

Thanks in advance.
 
E

Ed Robichaud

1 - Every form (perhaps your main menu) has OnTimer and TimerInterval
properties that you could use to measure a time interval and then display a
msgbox or open a pop-up form.

2 - If your export procedure has an "OnError.....goto Exit" statement (and
it should) then you can force an error and exit from your loop. I've never
used it, but you could also use the Windows API to check for "Ctrl-Break".

-Ed
 
S

scadav

1 - Every form (perhaps your main menu) has OnTimer and TimerInterval
properties that you could use to measure a time interval and then
display a msgbox or open a pop-up form.

2 - If your export procedure has an "OnError.....goto Exit" statement
(and it should) then you can force an error and exit from your loop.
I've never used it, but you could also use the Windows API to check
for "Ctrl-Break".

-Ed
Click to expand...


For answer #1 - THANK YOU. I didn't even realize that was there, that
works great.

For answer #2 - can you clarify what you mean by use the Windows API to
check for "Ctrl-Break". I am somewhat of a novice at access programming.

Thanks again.
 
Top