Date Triggers, to move info from one table to another?

H

Hem13P

I need code or a macro to move data from one table to another on a date/ time
trigger. So basically the data should move when the date has elapsed. Hence
allowing me to keep historic dates, from future dates, but not having to
physically move the info once the future dates have passed. Any help please,
many thanks.
 
M

[MVP] S.Clark

Create an append and delete query to handle the copying and deleting data
from the primary table.
Create a macro that uses the OpenQuery Action to execute the two queries.

Next, determine what mechanism you want to use to execute these queries on a
timely basis.
May I recommend Total VisualAgent?
http://www.fmsinc.com/products/agent/index.html
 
H

Hem13P

Thanks a million. I have just managed to do that, and it works a wonder. I
just need to solve how to the run the macros in the correct order (ie. moving
data before deleting data). I have taken note of your suggestion and will
investigate. Is there any way that I can create another macro that will run
the others in the order that i want and then stick a button on the
switchboard manager that will operate the whole function in one?

Thanks again - thats just made my day!!
 
Top