[AccessD] Another challenge I need help with

[Darryl Collins]

THIS!!

I recommend you use both a 'delete' flag PLUS and time and date the record was flagged as inactive / deleted.  That way you can know determine when to apply that record to any historical queries (or not).

Cheers
Darryl.

-----Original Message-----
From: AccessD <accessd-bounces at databaseadvisors.com> On Behalf Of Susan Harkins
Sent: Wednesday, 7 November 2018 9:35 AM
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Another challenge I need help with

Agreed. They'll tell you they won't need them, but then, they will. 

Susan H. 


I designed and used a framework for my forms.  All deletes in all tables
(forms) marked records inactive, and re-queried the forms to only show active records.  Managers were tasked with deleting inactive records if they so desired.  Very few ever did.

It was a bit more work of course with reports always filtering out inactive records.  But to be able to "un-delete" records was priceless.




-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com