[AccessD] A2003: Fire Multiple Functions at different times

Darren,
I have a program which I call The Magic Roundabout.  Basically there for
what you want but a lot more powerful in that it has Batches or Classes of
functions to run.  Schedules etc.  I can send the whole caboodle over if you
want. I have stopped development in it but would like somebody to continue
what has been done so far.  The only caveat is that any improvements are
offered to the list via a complete mdb.  The idea is that windows scheduler
loads The Magic Roundabout at a given time (or at boot)and it then sits
there running in the background and will do "whatever", singularly or
repeatedly or at intervals - as determined by the setup by the user.  All
highly  configurable.  One thing it does, for example, is that at a given
time it shells out and loads TrueCrypt,mounts the drives (thus making the BE
available to users) and then later in the day unmounts the TrueCrypt drives
thus users do not see or even known that the BE runs is an encrypted pseudo
drive.  But if  Roundabout is loaded outside of the time params for this
particular event then it will not mount truecrypt thus protecting it.

Let me know
Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren D
Sent: 10 February 2009 05:28
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] A2003: Fire Multiple Functions at different times

Hi Team

I have a well used main form that has quite a few procedures that fire when
tabs
are clicked or buttons pushed etc

What I'd like to do is move some of the procedure (function) names to a
'function' table and have theses procedures fired off at durations stored in
this 'function' table

I have this in place now for 1 procedure that runs every 10 minutes using
the
timer on a hidden form bound to this 'function' table

This hidden form opens and sits hidden each time the main form is opened and
is
closed when this main form is closed

I'm sure someone here must have done something like this in the past 

So I just wanted to know what logic to apply to the 'function' holding table
and
how to handle multiple, competing and even conflicting durations

Perhaps not necessarily with the timer of this hidden form

 

I had in mind...

 

Table Name = tblFunctionToBeRun

Field1 = ProcedureName = String (EG: a value might be fGetUserName())

Field2 = HowOften = Number (EG: A value might be 10 to indicate run every 10
Minutes or 60 to run every hour) 

Field3 = TimeStamp = TimeDate fields (I can get the relative functions to
write
back just so I can see if it has occurred)

 

And so on 

 

Many thanks in advance

 

Darren

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com