• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3137
  • Last Modified:

Application.OnTime in Access.

Hi Team,

Is their any alternative to teh application.ontime that I use in excel.  I wnat a similar function in MS Access.
0
Sandesh555
Asked:
Sandesh555
  • 5
  • 5
1 Solution
 
danishaniCommented:
Yes check the On Timer event of your Form in combination with the Me.TimerInterval.

HTH,
Daniel
0
 
Sandesh555Author Commented:
Basically I want to run a macro created in MS Access every 5 minutes.
0
 
Sandesh555Author Commented:
Can you give me the syntax.   For example I am in Macro "ABC" and when I run the Macro "ABC", it should start to run itself every 5 minutes.  

So the Macro will call its own run every time in completed a run.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
danishaniCommented:
Yes you can do this using a Form based on a TimerInterval of 300000.

In the Timer event of your Form you place this code:
DoCmd.RunMacro "mcrYourMacroName"

HTH,
Daniel
0
 
danishaniCommented:
The TimerInterval you place in the On Open event of your Form:

Me.TimerInterval = 300000

Then in the Timer event of your Form you place this code:
DoCmd.RunMacro "mcrYourMacroName"

HTH,
Daniel
0
 
Sandesh555Author Commented:
Sorry I am new to Access. :(  What to you mean by form and the timer event...
0
 
danishaniCommented:
Ok no problem, I can create a demo for you in Access, which version do you use?

Daniel
0
 
Sandesh555Author Commented:
I am working on a module and not on a user form.  If that's what you meant by Form..
0
 
Sandesh555Author Commented:
Access 2007
0
 
danishaniCommented:
Well yes, but you can open the form in Hidden mode, so it wont bother you.

You problably can code this also in VBA ...

 TimerDemo.accdb
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now