Solved

Creating a Log of changes made (1)

Posted on 2014-01-22
3
200 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

763 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