Solved

Global variable with recordsets

Posted on 2014-01-06
2
273 Views
Last Modified: 2014-01-10
My task is to create a historical record of a database record change.  Example:  User opens a record.  Modifies it.  Saves it.  My history table should have record1, the original record before changes.  Then record2, the record after changes.

My plan:
User selects record to edit.
Save that record as in an array or recordset(?)
Edit record.
On save in history table save original record from array or recordset, then save new record.
Then save changes in original table.

There are about 50 fields.  I'm trying to avoid handling them one by one.

Does this plan make sense?  
Can I create a global recordset variable, save the original recordset to it, and then use it later?  Another way?  

Thanks,
Brooks
0
Comment
Question by:gbnorton
2 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39760476
Brooks,

 Have a look at the following:

http://allenbrowne.com/AppAudit.html

Which is a complete drop in Audit trail solution.

Jim.
0
 

Author Closing Comment

by:gbnorton
ID: 39771621
Thank you Jim.  Perfect.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question