[AccessD] Another challenge I need help with

[Arthur Fuller]

Stuart,

With all due respect to your brilliance, in this case I think that you are
incorrect.I think that a simple Deleted Flag is way wrong> As I tried to
demonstrate in my previous email, the database needs to construct the
situation as it existed on July 14, 2008, and any other date you might
choose.Who were your physicians at that date, and who re your lovers, and
your children? All of these are Time-Sensitive, and a simple solution such
as your proposed Deleted suggestion just won't cut it. I want to know who
your physicians were in 2017 and 2016 and everything backwards. I want to
know how many of them have been over-prescribing fentanyl. I don't consider
this an issue of privacy, but of criminal investigation.

On Tue, Nov 6, 2018 at 9:00 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Agree 100% I very raarely llow deletions..  It makes historical reporting
> impossible.   Like you
> I favour an activeinactive of IsDeleted flag over actual deletions.
>
>
> On 5 Nov 2018 at 20:02, John Bartow wrote:
>
> > I have at least one application where the delete marks the account as
> > inactive rather than actually deleting the record. All displays then
> > filter for active. There's an administrator level function to review
> > inactive accounts with the ability to actually delete the record.
> >
> > -----Original Message-----
> > From: AccessD <accessd-bounces at databaseadvisors.com> On Behalf Of
> > Stuart McLachlan Sent: Sunday, November 04, 2018 1:54 PM To: Access
> > Developers discussion and problem solving
> > <accessd at databaseadvisors.com> Subject: Re: [AccessD] Another
> > challenge I need help with
> >
> > Yes, I often do that.
> >
> > I also sometimes use a second message that prompts "Are you real sure
> > that you want to delete this record".
> >
> > In one application I actually had a third one:
> > "LAST CHANCE - ARE you REALLY SURE you want to delete this record!"
> > :)
> >
> >
> > On 4 Nov 2018 at 15:12, Joe O'Connell wrote:
> >
> > > Maybe it is just my users, but they sometimes need to be protected
> > > from themselves from automatically hitting the enter key whenever a
> > > msgbox is displayed instead of reading the message.  Instead of just
> > > acYesNo, I add an option to default to No and to display a question
> > > mark so  the buttons become vbYesNo+vbDefaultButton2+vbQuestion
> > >
> > > Joe O'Connell
> > >
> > > -----Original Message-----
> > > From: AccessD <accessd-bounces at databaseadvisors.com> On Behalf Of
> > > Stuart McLachlan Sent: Saturday, November 3, 2018 4:01 PM To: Access
> > > Developers discussion and problem solving
> > > <accessd at databaseadvisors.com> Subject: Re: [AccessD] Another
> > > challenge I need help with
> > >
> > > The way I do this is something like:
> > >
> > > Assuming the bound column is cboPepole is PE_ID, then
> > >
> > > Sub CmdDelete_OnClick:
> > >
> > > If msgbox,"Are you sure you want to delete this
> > > record",acYeseNo,"About to delete Record" = vbYes Then
> > >
> > >     CurrentDb.Execute "Delete * from tblPeople where PE_ID = " &
> > >     cboPeople Msgbox ""Record Deleted"
> > >
> > > Else
> > >
> > >    Msgbox "Deletion  cancelled"
> > >
> > > End If
> > >
> > > End Sub
> > >
> > >
> > > On 3 Nov 2018 at 13:29, Tina N Fields wrote:
> > >
> > > > Hi All,
> > > >
> > > > Here's what I'm trying to do:
> > > >
> > > > A combobox shows the list of individuals in the database The user
> > > > selects a particular individual from the combovox The user clicks
> > > > a button to delete that individual's record from the tblPeople A
> > > > message box pops up to ask "Are you sure you want to permanently
> > > > delete this record?" The user responds either with a 'Yes" or a
> > > > "Cancel." If the user clicks "Yes," that individual record is
> > > > deleted from the tblPeople.
> > > >
> > > > I have the form with the combobox in place. It is populated with a
> > > > query selecting the individual's ID, the individual's name, the
> > > > family name (not always the same as the indifidual's last name),
> > > > and the assigned family code. The bound column is the PE_ID, which
> > > > is not displayed. (The family name and code are just so the user
> > > > can be sure which John Smith is being selected, in case of more
> > > > than one in the database.)
> > > >
> > > > I need help figuring out the rest of this. Any ideas?
> > > >
> > > > Thanks,
> > > > T
> > > >
> > > > --
> > > > Tina Norris Fields
> > > > 231-322-2787
> > > > tinanfields-at-torchlake-dot-com
> > > >
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > >
> > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur