[AccessD] Another challenge I need help with

[Darryl Collins]

Hah! I should have read this before replying to Susan's comment.

Arthur is correct.  A simple 'delete' flag is not that useful.  You need to know when the record was flagged as 'deleted' as well.

Cheers
Darryl

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

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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com