表级事件时的数据是MSACCESS表格上改变了？ [英] Form level event for when data is changed on a MSAccess form?

问题描述

嗯，基本上我工作的一个MSACCESS应用程序和形式，其中管理人员会认为，我想编辑的用户数据能够调用的事件与现场的旧的和新的值时，它改变的。此功能将添加一条记录到审计表来跟踪更改。

Well basically I am working on an MSAccess application and on the form where administrators will view and edit user data I want to be able to call an event with the old and new values of a field whenever it is changed. This function will add a record into the audit table to track changes.

我有没有问题创造了查询项添加到审核表，但我不知道在哪里放置函数调用。我已经尝试了一些表单级事件，所以我没有去到每一个五十场和编辑他们的onblur事件，检查是否有新的价值，但没有运气。

I have no problem creating the query to add the entry to the audit table but I don't know where to place the function call. I've tried a few form level events so I don't have to go into each of the fifty fields and edit their onBlur events to check for a new value but have had no luck.

任何提示将受到欢迎。

推荐答案

微软对此有一篇文章：如何在Access中创建的形式记录更改的审计线索2000 。

Microsoft has an article on this: How to create an audit trail of record changes in a form in Access 2000.

这篇关于表级事件时的数据是MSACCESS表格上改变了？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！