setting a timer

[Guest]

Just wondering how to set a timer to calculate the number of days a field
changed.
I tried setting up a new table to record the sequence of changes but i can't
seem to have the table to add a new record in the new table each time a field
changes automatically from an old table.
Attempted to build an event procedure through visual basic coding - stuck on
how to transfer the data from one table to another.
Anyone's help would be greatly appreciated.

 

[Guest]

Just wondering how to set a timer to calculate the number of days a field
changed.
I tried setting up a new table to record the sequence of changes but i can't
seem to have the table to add a new record in the new table each time a field
changes automatically from an old table.
Attempted to build an event procedure through visual basic coding - stuck on
how to transfer the data from one table to another.
Anyone's help would be greatly appreciated.

To transfer data from one table to another, look in help file for Update Query.
To run on a timer you will have to use the timer event on a form. However, if
you limit the data changes to form operations up front, it would be just as easy
to have the Update Query execute each time the data in the original table is
changed (ie saved) from the original form and don't use the timer at all.

gm