?
Solved

Creating a Log of changes made (1)

Posted on 2014-01-22
3
Medium Priority
?
203 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 300 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

800 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