Scheduling Macro to Run Every X minutes

C

Chris

I have created a macro that essentially performs a check
of a ticket queue and then calls some VB code to notify a
group over IM software. I would like to set up Access to
either run this macro every X minutes, or have the macro
simply loop itself and put a pause it it. Does anyone
know how to accomplish this?
 
S

Steve Schapel

Chris,

If you have a form which is always open, you can set its Timer Interval
property to (X*60000) and assign your macro on the forms On Timer event.
You will have to be careful, though, that this wouldn't cause a
problem if the macro runs when someone is right in the middle of editing
data or some other process.
 
R

RhythmAddict

Chris said:
*I have created a macro that essentially performs a check
of a ticket queue and then calls some VB code to notify a
group over IM software. I would like to set up Access to
either run this macro every X minutes, or have the macro
simply loop itself and put a pause it it. Does anyone
know how to accomplish this? *



Did you ever find a solution to this? Im looking to do somethin ver
simliar...thanks


-
RhythmAddic
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top