Solved

Creating a Log of changes made (1)

Posted on 2014-01-22
3
197 Views
Last Modified: 2014-02-08
Hi all,

my initial inquiry in essence is the following.

I have a table with data.

I have a form which allows amendments to certain fields of this table. Other fields are locked so that the user cannot amend.

I was wondering if it is possible to create a log of the changes made to those allowable fields?

[working with MSAccess 2003]
0
Comment
Question by:PipMic
  • 2
3 Comments
 

Accepted Solution

by:
marlind605 earned 150 total points
ID: 39800670
Try this function in Allen Browne's website. Looks complicated at first but just follow the steps.http://allenbrowne.com/appaudit.html
0
 

Author Comment

by:PipMic
ID: 39806629
Hi,

found this one which is far simpler but dont know if it works on 2003. Must test.
0
 

Author Closing Comment

by:PipMic
ID: 39843816
Difficult to implement
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

912 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now