Paul Rodgers
Paul.Rogers at SummitMedia.co.uk
Tue Aug 3 09:33:16 CDT 2004
This is an idea I hadn't thought of. But it seemed to me a separate table would be the handiest place for seeing 'deleted' files, and deciding if some information mightn't be better kept. Many thanks, Jim Cheers paul -----Original Message----- From: Jim Hewson [mailto:JHewson at karta.com] Sent: Tuesday, August 03, 2004 3:08 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Coding for backing up deletes What she really is telling you that she's not sure if she wants to delete at all. First blush, I think, I would take all deleting capabilities away. In the form properties, change the Allow Deletions to No. Hide the record selectors and add a delete button. Add a small "ysnDelete" Y/N field in the primary table. When the "delete" button is pressed, it would toggle the field to Yes (as in Delete) and then all queries etc. would not show that record. The form could then be refreshed to show that record has been "deleted." Another form could be built to show the "Deleted" records and any record she needs to "Undeleted" could then be reactivated. Any record that truly needs to be deleted can then be separated out and permanently removed. Pros: It's not too difficult to add the field and change a few queries. A little tweaking and it shouldn't be too difficult. Cons: Forms will have to be modified to remove the true delete function of the form. Tracking all queries, forms, reports where the new field could be time consuming. Just one way this could be done. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Paul Rodgers Sent: Tuesday, August 03, 2004 8: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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com