审计跟踪将更改为空 [英] Audit Trail That Captures Change To Null

问题描述

我在互联网上找到了创建审核日志的代码。如果您编辑一个值变为空白，它将无法记录，但效果很好。我尝试了一些东西而不能让它起作用。任何人都可以帮忙吗？在此先感谢。

Hi, I found code on the Internet for creating an audit log. Works great except it does not record if you edit a value to become blank. I tried a few things and can''t get it to work. Can anyone help out? Thanks in advance.

展开 | 选择 < span class =codeDivider> | Wrap | 行号

推荐答案

barbaro，

此代码看起来非常好。你真的没有告诉我们关于这个问题的本质。当您将任何字段更改为空白时，是否无法生成审核记录？问题可能发生在

barbaro,
This code looks pretty good. You don''t really tell us anything about the nature of the problem. Does it fail to make an audit record when you change any field at all to be blank? The problem is presumably occurring at

展开 | 选择 | Wrap | < span class =codeLinkonclick =LineNumbers（this）;>行号

实际上，

我建议不要使用[F9 ]停止点。

已经证明它会导致编译器出现问题。

而是插入 STOP 命令中间第7行和第8行（在第一个 SET 命令之前）。

从那里开始按照jimatqsi的建议继续。


请查看此处的故障排除部分：
>发布前（VBA或SQL）代码


并查看 Microsoft Access / VBA Insights Sitemap 列表（打开页面然后使用< ctrl>< f>打开页面搜索以查找在vba中调试 ;或者寻找129到139 ...

Actually,
I recommend against using the [F9] stop point.
It has been documented to cause issues with the compiler.
Instead, insert the STOP command in-between lines 7 and 8 (just before the first SET command).
From there proceed as jimatqsi has suggested.

Please take a look at the trouble shooting section here:
> Before Posting (VBA or SQL) Code

AND take a look at the trouble shooting articles in the Microsoft Access / VBA Insights Sitemap listing (open the page and then use <ctrl><f> to open the page search to find "debugging in vba" or look for 129 thru 139...

当我从值1更改任何字段时，代码工作正常。到值2。更改将在审计表中正确记录。如果我将值2更改为空（空白），则更改不会记录在表中。我相信这是jimatqsi建议的行和我试过

Hi,

The code works fine when I change any field from "Value 1" to "Value 2". The change gets recorded properly in the audit table. If I change "Value 2" to be null (blank), the change is not recorded in the table. I believe it is the line jimatqsi suggested and I have tried

展开 | 选择 | Wrap | 行号

这篇关于审计跟踪将更改为空的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！