move records from table to table

[chuckym7]

Im using Access 2000. I have a table for employees. I have a table for employyes no longer with the company called archive. How can I move a employee record to the archive table? Thank you so much in advance

 

[SilentAiche]

chuckym7,

Welcome to Tek-Tips.

May I offer a different solution? I would strongly recommend having a single employee table and adding a [blue]status field[/blue] (Current/Former or Active/Inactive or Tolerated/Fired...). You get the picture. You might even add a date field to track when the status changed.

Moving the records from table to table is doable, but I believe best practices would say to add a status field.

Good Luck!
Tim

[blue]__________________________________________________
If you need immediate assistance, please raise your hand.[/blue]

 

[chuckym7]

Great idea. I will add that combo box. Is there a way I can make all "non employees" hidden once status is changed? Then make a seperate query to show former emplyees? thanks again

 

[jlrrush]

You can add a filter to a form that will only show records that have a null or active status (depending on how you set up your status column).

 

[chuckym7]

excellent! ITs working great!. Lastly , can I apply the filter "on open" of the form. Have the filter start as soon as I open the form?

 

[chuckym7]

I just made 2 queries to solve my last part of the questions. I all set thank you for the GREAT IDEA!!!!!

 

[SilentAiche]

Glad it worked. I kinda miss my old database...

Tim

[blue]__________________________________________________
If you need immediate assistance, please raise your hand.[/blue]