How to log record deletions in a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ryc syc - 22 Apr 2008 22:26 GMT

I need to log deletions of records and copy the deleted record to a table. I've tried a few different examples but cannot get them to work properly. VB Novice over here.

Reply to this Message

KARL DEWEY - 22 Apr 2008 23:40 GMT

The best way is to add a flag field (Yes/No) to signfy archived/deleted
records. Add criteria to all your queries to not pull archived/deleted
records unless you are doing stuff with history.
Just add a checkbox on your main data entry form bound to the
archived/deleted field. Once checked they disappear after closing the form.

Signature

KARL DEWEY
Build a little - Test a little

> I need to log deletions of records and copy the deleted record to a table. I've tried a few different examples but cannot get them to work properly. VB Novice over here.

Reply to this Message

Jeff Boyce - 23 Apr 2008 00:07 GMT

As Karl points out, you can save yourself a lot of work if you don't "move"
the records from table to table.

You didn't mention the volume of records you're dealing with ... if you have
millions of rows and/or your db is over 100 Mbytes and growing, you might
actually need to move records (or move up to a db engine with greater
capacity).

Good Luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

>I need to log deletions of records and copy the deleted record to a table.
>I've tried a few different examples but cannot get them to work properly.
>VB Novice over here.

Reply to this Message