Help on delaying a look

[Morgan]

I have a VB App. that I made that accesses an access db,
I want to run a never ending look then the vb app opens,
but I don't know how to delay the loop. I want to delay
the look every 60 minutes. Meaning, I want it to lunch a
function called "CalculateWeeksUD" every 60 minutes while
the app is open.

any Ideas, Thanks Morgan

 

[Sandra Daigle]

You might want to use the sleep api - here's a wrapper function that works
in VBA: http://www.mvps.org/access/api/api0021.htm

In Access you can also have a timer event on a form. As long as the form is
open the event will fire at each predefined interval.

 

[Wayne Morgan]

In addition to Sandra's suggestion, if the timer is run from VB, one of the
controls that can be added to a form in VB is a timer control. It's not
built into the form as it is in Access.