John W. Colby
jwcolby at colbyconsulting.com
Tue Aug 3 08:56:34 CDT 2004
Paul, Create a "deleted" flag in the table. When the user does the delete, mark the record as deleted. The form only displays records with the deleted flag = false. You might want to make the deleted flag a date field set to null initially, then set to the data (and even time if needed) of the delete. Now you can run code that really deletes data (or archives it) that is deleted longer than X days ago. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Rodgers Sent: Tuesday, August 03, 2004 9:35 AM To: 'Access Developers discussion and problem solving' 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