Solved

Creating a Log of changes made (1)

Posted on 2014-01-22
3
201 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Office 365 Training for IT Pros

Learn how to provision Office 365 tenants, synchronize your on-premise Active Directory, and implement Single Sign-On.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
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…

739 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