[AccessD] Coding for backing up deletes

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




More information about the AccessD mailing list