Archive old records

[treva26]

I have a database of employees.

What I would like is a button that removes the current employees record from the database and exports it to a seperate Archive database.

The reason being that when an employee leaves they are taken off the main database but the info is still accessible is nescasary.

Is this possible?
I know how to add the code and link it to a button, but dont have a clue about writing the actual code.
Would the archive database need to be opened? If so could it be closed again and all this done without the user seeing what is going on?

 

[pbaldy]

It's possible, but I wouldn't recommend it unless you're talking about a massive number of records. The more common solution is to add a "status" field to your existing table, and change the status when an employee leaves. When you want a list of current employees, simply add the appropriate criteria to your query.

 

[treva26]

Yea you are right, I will do that.

One slight problem, I have made my main form to get data directly from the table.
Can I change it to get its data from a Query?
Or do I have to make the whole form again?

 

[pbaldy]

You should be able to switch the source to a query. Just change the form's record source property.