Run Process on Schedule

[martinjward]

Is there anyway to / can anyone give me some pointers how to run process data on a interval (native within Access)

What I really want to do is create a module that call a couple of functions to be run every two hours between the hours of 7am and 7pm.

 

[HiArt]

Hi, just google "VB Timer", it too is native!

here's one solution out of many

h**p://www.morrowland.com/apron/tutorials/vb/vb_timer/index.php

So....

set your timer up with 7200000 (7,200,000) 120 minutes in milliseconds

You can use "if Hours(now()) > 7 and hours(now()) < 19" type selection to make sure the call to the timer falls within bounds.

I think.....

ART