Access 2000

[Jessica]

I have a database with misc. information for all of my
company's employees. There is a drop down with options
such as "active", "not active", etc. for the employee's
current status with the company.

My question: When an employee becomes something other
than "active", is there a way to have their data
automatically go into another database or just somewhere
other than the current database? I'm trying to figure out
a way to do this so I don't have all of the terminated
records mixed in with the active records.

 

[Howard Brody]

Yes, you can build a process for moving all the terminated
employees to another table (or database) but my question
is how many employees and records do you have? It's
probably just as easy to add an 'Active=Yes' criteria to
your queries and filters.

 

[J. Thomas Coons]

Make another new, empty database to contain the inactive
records. Make a select query that finds inactive records
in the working database. Make a copy of this select query.
Change one copy of the select query to a make-table query,
and have it make a new table in the inactive records
database. Then, change the make-table query to an append
query to the same table just created. Change the other
copy of the select query that finds the inactive records
to a delete query. Have the append query and then the
delete query run in an event procedure, such as when you
press a command button, or when you close a form, for
example. To make it really automated, you could put code
to conditionally run the append query and then the delete
query in the "on update" event of the field on the form
that changes the record from active to inactive.