Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 1st, 2004, 12:05 AM
Registered User
Join Date: Feb 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Knowing what is added/deleted in subform?

I have an order entry app that will also keep track of inventory stock quantities.

If a customer adds or deletes products in a typical order entry subform, how do I know what they added or deleted so I can update the inventory?

Is there a way to read each line of the subform so I can tell what is going on during an update or delete?

What is the best way to accomplish this?

Seems this would be easily accomplished using a trigger in SQL Server, but how is this done in an Access subform?

Old September 21st, 2004, 12:22 PM
Friend of Wrox
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts

Try Rick Dobson, "Programming Microsoft ACCESS Version 2002", pg 501.
Regards Penta.

Old September 21st, 2004, 02:42 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG

Add a date/time field that stamps when the action was taken. When a record is added, the current date and time (based on the user's computer clock) is stored.

For deletions, don't actually delete the record. Instead, mark or flag the record for deletion. If you use a checkbox for that, the date/time stamp would stamp the time the checkbox was clicked.

In the future, when you want to list all active (i.e. those records not marked for deletion) records in a report or listing in a form/subform, filter the report/form to only include those where the checkmark is unchecked (i.e. value FALSE).

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Similar Threads
Thread Thread Starter Forum Replies Last Post
traverse the whole tree without knowing the node dipsut XSLT 3 June 17th, 2011 07:49 AM
Knowing the Browser Type me_zeta HTML Code Clinic 1 November 13th, 2006 01:44 PM
How knowing it is an integer? rtr1900 Classic ASP Basics 1 October 5th, 2006 07:40 AM
What r different ways of knowing values in Object? amit_mande@yahoo.com VB.NET 2002/2003 Basics 1 September 27th, 2006 02:48 PM
Knowing File Path x_ray VB.NET 2002/2003 Basics 8 February 15th, 2006 04:12 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.