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.
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.
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).
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.
