[AccessD] Another challenge I need help with

[Stuart McLachlan]

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
>