Scheduling Macro to Run Every X minutes

  • Thread starter Thread starter Chris
  • Start date Start date
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?
 
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.
 
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? *
Click to expand...



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


-
RhythmAddic
 
Back
Top