Moving/Deleting Records

S

SammyH

Hi,
I'm really new to access and am trying to create a customer database. I've
got the basics mastered using templates but I'm concerned about deleting
records. What I would like to happen is:
If I delete a record from the main database it removes it from there and
saves/copies it in another "backup" table. Is this possible?
Thanks for your time in advance!
SammyH
 
K

KARL DEWEY

The better way is to add a Yes/No field to your database named something like
Archived. When a record is old then flag it as Archived. But the data is
available when needed. In your queries include criteria for Archived field
as 0 (zero) or No.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Active Content in this file is blocked issue 1
Copy previous record into form field 0
Synchronization problems while moving folders to new email 1
Invoicing and customer database 0
Overriding constraint restriction message, when deleting record(s) from form 6
Delete record error form / subform 1
Two Delete Record Problems 1
How do I combine records from different sources 0

Top