Moving Info from One Table to Another On a Date/ Time Trigger

H

Hem13P

I need to move data from one table to another, on a date/ time trigger. I
would like to move the data at the end of the same working day that it was
entered via a form into the first table. Can anyone suggest a macro
preferebly, or some code to do this. Thanks in advance for your help.
 
G

Graham R Seach

There's no inherent way to do this. The only way is to launch a hidden form
on startup. Code in this form's Timer event should periodically check the
time, and if the correct date/time is reached, move the data.

Of course, this doesn't help you if the user has shutdown the database prior
to the trigger date/time.

Another way is to use Windows Scheduler to launch the database using the
/macro command-line argument.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Top