saving a copy of deleted records

[nod]

I am writing a vb6 interface for an access database.
I want to be able to delete records so they no longer register on the
database but at the same time it would be good if all the deleted data
was stored away somewhere - rather like the recycle bin in Windows.

I would welcome suggestion on the best way to do this.
Is there any standard way to do it?
There are a number of related tables with 'Cascade Delete Related
Records' set.

Thanks
Nod

 

[scubadiver]

The easiest thing to do would be simply to add a checkbox to the table so
that if you don't want people to see certain records tick it.

Don't base the form on the table but on a filtered select query that
excludes unseen records.

Then you don't have to delete them at all.

 

[Linq Adams via AccessMonster.com]

I also use scubadiver's suggested method. I have a "twin" form for displaying
"deleted" records (the underlying query only selecting records with the
"deletion" box checked) with the background color being different to
differentiate the two forms. An advantage of this method, in addition to
easily retaining old records, is that if a record is accidentally "deleted"
it can be re-instated by simply going to the "deleted" form and unchecking
the box! Beats re-entering bunches of data!

The easiest thing to do would be simply to add a checkbox to the table so
that if you don't want people to see certain records tick it.

Don't base the form on the table but on a filtered select query that
excludes unseen records.

Then you don't have to delete them at all.

I am writing a vb6 interface for an access database.
I want to be able to delete records so they no longer register on the

[quoted text clipped - 8 lines]

Thanks
Nod

 

[Klatuu]

You don't really need two forms. Why have to modify two forms when you can
do it with one?
I would suggest a toggle button that would change the filtering of the form
and change the colors as desired.
--
Dave Hargis, Microsoft Access MVP

I also use scubadiver's suggested method. I have a "twin" form for displaying
"deleted" records (the underlying query only selecting records with the
"deletion" box checked) with the background color being different to
differentiate the two forms. An advantage of this method, in addition to
easily retaining old records, is that if a record is accidentally "deleted"
it can be re-instated by simply going to the "deleted" form and unchecking
the box! Beats re-entering bunches of data!

The easiest thing to do would be simply to add a checkbox to the table so
that if you don't want people to see certain records tick it.

Don't base the form on the table but on a filtered select query that
excludes unseen records.

Then you don't have to delete them at all.

I am writing a vb6 interface for an access database.
I want to be able to delete records so they no longer register on the

[quoted text clipped - 8 lines]

Thanks
Nod

 

[JohnE]

I am with Klatuu on this as well as scubadiver and Ling. I too use a
checkbox to remove the unwanted record. But, as sure as I am typing this
out, someone will wish they had the information back. Unchecking the
checkbox is easier then creating duplicate tables, forms, etc. If you do not
want the users to be able to uncheck the "deleted" record, you can put a
hotspot on the form that you know about and can use to toggle like Klatuu
indicated. No need for overkill on tables, forms, etc. Happy coding and
enjoy.
.... John

You don't really need two forms. Why have to modify two forms when you can
do it with one?
I would suggest a toggle button that would change the filtering of the form
and change the colors as desired.
--
Dave Hargis, Microsoft Access MVP

I also use scubadiver's suggested method. I have a "twin" form for displaying
"deleted" records (the underlying query only selecting records with the
"deletion" box checked) with the background color being different to
differentiate the two forms. An advantage of this method, in addition to
easily retaining old records, is that if a record is accidentally "deleted"
it can be re-instated by simply going to the "deleted" form and unchecking
the box! Beats re-entering bunches of data!

The easiest thing to do would be simply to add a checkbox to the table so
that if you don't want people to see certain records tick it.

Don't base the form on the table but on a filtered select query that
excludes unseen records.

Then you don't have to delete them at all.

I am writing a vb6 interface for an access database.
I want to be able to delete records so they no longer register on the
[quoted text clipped - 8 lines]
Thanks
Nod

 

[nod]

Great suggestions.
Thanks everybody.

Nod