Microsoft Access - Cutting and Pasting between tables

[puck4343]

Currently, we have a database here that keeps records of all our
inventory that is out in production. When we have a piece of equipment
that is removed, it needs to be put into a removal table for
accounting/auditing purposes. Anyway, my question is - Is there a way
when I use the delete key to automatically cut it from one table and
paste it in the the removal table?

 

[Douglas J. Steele]

Currently, we have a database here that keeps records of all our
inventory that is out in production. When we have a piece of equipment
that is removed, it needs to be put into a removal table for
accounting/auditing purposes. Anyway, my question is - Is there a way
when I use the delete key to automatically cut it from one table and
paste it in the the removal table?

There's nothing like that built into Access, largely because that's not the
normal way to work with relational databases.

If you know the table you're getting your data from and the table to which
you want to write it, you could create an AutoKeys macro that would cause
whatever code you wanted run to run. However, that would mean that you'd
then be unable to use the delete key for anything else.

 

[Pieter Wijnen]

or if you (as you should) use forms for data manipulation, you can add code
to the
Form_BeforeDelete event to duplicate the record - Or consider adding a field
to the table & use a query to filter out the delete items instead
--
Pieter Wijnen

My feeble Access pages (good links though)
http://www.thuleeng.com/access
When all else fail try:
http://www.mvps.org/access
http://www.granite.ab.ca/
http://allenbrowne.com/
http://www.lebans.com/