Hello Community,
I want to create a delete table to keep track of printers deleted from my database. Is there a way to set up a table like this that when I delete a printer, it moves the deleted printer and it's config information to a separate table which can be looked at to keep track of the printers that were no longer needed?

Where will the field values of the deleted printers be coming from?
For example you have a table with inventory of printers named tblPrinters.
I suggest in this tblPrinters table you create a field name Deleted with Date type Yes/No. Assuming you already created a tblPrintersDeleted, the next step is to create an Append query to
add all records from tblPrinter with Deleted field value of Yes.
Check the result after you run the query. See if all Yes value of Deleted field are in tblPrintersDeleted.
Then created a Delete query to delete all records from the Deleted field value of Yes.
I hope this helps.
john

That really sounds like a good idea, however, I would like to make it a little more automated. I could see having a query to do this all in one operation, but is there a way to eliminate the step of having to go into the table to check the Yes box for deleted?

What will be you basis then to do it?
Unless, you have another field to get a criteria. Like 4 example in our email messages, you have a date field msg was received and want to archive messages for more than a year.
john

I guess I will need to use VBA in order to do something as complex as what I have in mind.

Hello,
I don't think what you are doing requires VBA except for the command button that executes it. Take a look under Access help at "Create an Append Query." This will give you step by step instructions on how to create this query. It is actually pretty easy.

I have a specification database that lists all specifications that our automotive parts must meet. I use this append query every time one of those specifications are obsoleted/inactivated. This pulls the record out of the active spec table and moves it to the obsolete spec table. I think this is exactly what you are wanting to do with your printers.

I hope this helps!

Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

Thanks Laura,
The problem with the append query, unless I am wrong, is that it will append the data into another table but then you have to go back into the table and delete the data. I may be wrong and I am not trying to argue, but it just seems like that is going to require too many steps. I will try it again though, just to be sure.:)