Using a Form to Archive Old Data

  • Thread starter Thread starter Zeunasc
  • Start date Start date
Z

Zeunasc

Hello all:

I have a table that contains some data, including a EmpDate field. I
have a query that will bring up the last 90 days worth of data, based
on that date field.

What I need is to be able to bring up that 90 day history, click on a
record, and hit a button that will move that record from the live
table to an archive table, and append an "archived date stamp" to the
record in the new table.

I can provide more data or information if necessary, but I don't even
know where to start with this one. I am assuming I will need to use
some sort of subform? Any help is appreciated.

TIA,
Tim
 
Hi Tim,

Why do you need to "move" the record to an archive table? You could simply
set an "Archived Date" in your existing table. To see records that have not
been archived, query where [ArchivedDate] is null.

You have plenty of events to choose from to set the Archived Date, perhaps
the double click event (which probably isn't going to be accidentally
triggered).

Hope this helps.

Damian.
 
Back
Top