Paul Rodgers
Paul.Rogers at SummitMedia.co.uk
Wed Aug 4 03:29:51 CDT 2004
Yes, that is great, Darren. Exactly the sort of thing I had in mind - only much cleverer. Oh yes, I'd certainly tell the User about the recoverability of 'deletes'. It's not putting them in the dark that I planned, just making things recoverable in a simple way. I'm much obliged. Thanks very much for that. Cheers paul -----Original Message----- From: Darren DICK [mailto:d.dick at uws.edu.au] Sent: Wednesday, August 04, 2004 1:43 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Coding for backing up deletes Hi Paul I rarely let my users 'delete' records In virtually all my tables I have a field called IsDeleted - Data Type = Number All my 'delete' buttons actually set the value for IsDeleted in that record to -1 Then the form refreshes to NOT show records where IsDeleted =-1 That way we can give the appearance (and make yourself look good in the process) of having the ability to undo or rollback when users 'stuff something up' after they have left the record or closed the form I actually then move (at whatever period suits) all records where IsDeleted = -1 to another table or dB I rationalise this to all my users (the ones involved at admin level in the design specs at least) and I haven't had anyone disagree (yet). In fact when you explain the benefits and low overheads al my customers (so far) agree it's a great idea. You can then build them an interface (I do) to recover 'deleted' records or data. I don't let 'em edit data through those interfaces - just recover 'deleted' records or REALLY delete - depending on Logon Permissions. It's all pretty transparent to the users and the Admin people really know what's going on and love the ability of a 2nd chance recovery or proper deletion Hope this helps Darren ----- Original Message ----- From: "Paul Rodgers" <Paul.Rogers at summitmedia.co.uk> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Tuesday, August 03, 2004 11:34 PM Subject: [AccessD] Coding for backing up deletes > Any of our craftsfolk ever coded for something like this please? > > The user wants to delete a file in a table. She goes to a form, and finds > the record. She clicks a button and the record is 'deleted' - only really it > goes into a waiting backup table ... just in case. > > Expert guidance would be appreciated. > > Cheers paul > > -----Original Message----- > From: Charlotte Foust [mailto:cfoust at infostatsystems.com] > Sent: Monday, August 02, 2004 7:27 PM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] Good Deal on Microsoft Office XP 2003 > ProfessionalEdition > > > But XP, Pro or otherwise, is 2002, not 2003. I wasn't clear on which > version of Office you were talking about. > > Charlotte Foust > > > -----Original Message----- > From: Lawhon, Alan C Contractor/Morgan Research > [mailto:alan.lawhon at us.army.mil] > Sent: Monday, August 02, 2004 8:38 AM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] Good Deal on Microsoft Office XP 2003 > ProfessionalEdition > > > Charlotte: > > It appears to me that the only difference between the "Home" and > "Professional" editions of Office XP is that the "Professional" version > includes Access. (The "Home" and "Student" versions do not include > Access.) > > Alan C. Lawhon > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte > Foust > Sent: Monday, August 02, 2004 10:27 AM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] Good Deal on Microsoft Office XP 2003 > Professional Edition > > > What is Office XP 2003 when it's at home? Office XP is 2002 and 2003 is > something else entirely. > > Charlotte Foust > > > -----Original Message----- > From: lawhonac [mailto:lawhonac at hiwaay.net] > Sent: Saturday, July 31, 2004 10:12 PM > To: accessd at databaseadvisors.com > Subject: [AccessD] Good Deal on Microsoft Office XP 2003 Professional > Edition > > > I've run across a deal on "Microsoft Office XP 2003 Professional > Edition" (Upgrade Version) which some of you might find interesting. Go > to Amazon.com's "Software Store" and you'll find the above product > available for a price of $269.99. This may not be the best price > available for the XP Professional (upgrade version) of Office, but what > makes this deal really interesting is the following "Special Offer" > which Amazon is attaching to orders placed in the next day or so: > > > Special Offer: Receive a promotional certificate for $50 off a future > Amazon.com purchase when you spend $250 in our Electronics and Software > Stores. Offer valid through August 1, 2004. (Applies only to products > sold by Amazon.com. Does not apply to products sold by third-party > merchants and other sellers through the Amazon.com site.) Here's how. > > > At $269.99, "Office XP 2003 Professional Edition" tops the $250.00 > threshold by just under $20.00 - plus you can get free "SuperSaver" > shipping because the order total exceeds $25.00. It must be a good > deal, because I noticed that this [upgrade version] of Office is > currently at 45 on Amazon.com's real time sales ranking. (I was looking > at the upgrade version of Office XP Professional tonight at a CompUSA > store. CompUSA's store price was > $329.99.) > > I have been considering the upgrade for quite some time, but this deal > clinches it. (I just ordered my copy from Amazon.) If interested, > you'll have to act fast - this offer expires today! > > Alan C. Lawhon > > > > -- > _______________________________________________ > 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