Go Back   Access World Forums > Microsoft Access Discussion > Queries

Thread Tools Rate Thread Display Modes
Old 07-07-2008, 01:49 AM   #1
Registered User
batwings's Avatar
Join Date: Nov 2007
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
batwings is on a distinguished road
Update query then record changed fields in new table

Hi There

I have an 2 tables that I am comparing and an update query and it works well when I use it to update changes from my tblUpdate to tblMaster I've even manage to have the records that have been updated marked with "U" in a field called Flag.

But what I would really like to have is a 3rd table to log the history and by history all I want is the ID field for the record plus the field(s) that were changed and what they were changed from/to.. I do not need to know by who, what computer, time, date or any of that. (At the moment I know what record was changed but not what field(s)...)

I have seen this done using forms and subforms in an Employees/Salary scenario it looked great but I have no need for forms.

Just some way to record in a 3rd Table exactly what has changed...

Or if there was some way to highlight the changes in one of my tables emboldened/coloured or whatever showing just which field(s) had changed in each of the updated records that would suffice...


Cheers Batwings
batwings is offline   Reply With Quote
Old 07-07-2008, 03:54 AM   #2
neileg's Avatar
Join Date: Dec 2002
Location: Newcastle, England
Posts: 5,975
Thanks: 0
Thanked 8 Times in 8 Posts
neileg has a spectacular aura about neileg has a spectacular aura about
You can't do this at table level because Access tables don't support triggers. Do a search for audit trail in these forums.
You can't always get what you want, but if you try sometimes you may just get what you need - Rolling Stones

Cheers, Neil
neileg is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting confused on method: Best way to update query by using combo box filters ST4RCUTTER Forms 6 01-08-2008 06:34 PM
Beginners question - Auto update fields based on fields in another table timmeahy Queries 2 11-26-2007 06:49 PM
way too many tables qwertyjjj Theory and practice of database design 3 08-01-2007 01:04 PM
Using update query in form to update table isoman53 Forms 0 01-21-2007 06:06 PM
choose table in parameter query poulsotw Queries 4 10-24-2005 01:41 AM

All times are GMT -8. The time now is 02:30 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World