Archiving & deleting a record from the main table

[Guest]

Hello,

I'm developing a database that would allow Managers to manage their dept.
profile by archiving an employee record from the main table and then deleting
it. I'd like to make this as simple as possible by requiring them to enter
the employee's number to retrieve the record for viewing in a form. Once
they've viewed the record, they can then archive and delete the record from
the main table. How can I do this without having them to re-enter the
employee's number again when they run the macro? My thoughts are to use two
separate queries, Append and Delete, without creating a parameter where they
would need to re-enter the employee number twice. If this is possible, how?

Thanks for any help you can give.

Maria

 

[Jack MacDonald]

Before going down that path, have you considered adding a
"CurrentEmployee" Yes/No field to the table. Simply change the value
from Yes to No for archived employees. Base your reports, forms on
queries that select Current or All employees as required. Saves the
hassle of maintaining two tables.

Hello,

I'm developing a database that would allow Managers to manage their dept.
profile by archiving an employee record from the main table and then deleting
it. I'd like to make this as simple as possible by requiring them to enter
the employee's number to retrieve the record for viewing in a form. Once
they've viewed the record, they can then archive and delete the record from
the main table. How can I do this without having them to re-enter the
employee's number again when they run the macro? My thoughts are to use two
separate queries, Append and Delete, without creating a parameter where they
would need to re-enter the employee number twice. If this is possible, how?

Thanks for any help you can give.

Maria

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

 

[Guest]

That's actually a very good suggestion, Jack. I'll try that instead. Thanks!