TimeStamping备忘录字段 [英] TimeStamping a memo field

问题描述

我在Access 2003的一个版本中看到了这个，但我不记得如何编写代码它。在我之前的程序员，当许多用户访问相同的文件时，将代码插入备忘录字段以列出用户名和时间戳条目（以及时间），以了解与客户沟通的内容，由谁什么时候。我记不起代码和我到目前为止所尝试过的所有内容，并没有得到我想要的结果。有谁知道如何编写这段代码？

解决方案

Private Sub MyMemoField_GotFocus（）

Me.MyMemoField = MeMyMemoField.Value& " " &安培; CurrentUser（）& " @" &安培;现在（）& " ："

End Sub

将此代码添加到AfterUpdate事件而不是每次获得焦点时可能更好。

我在Access 2003的版本中看到了这个，但我不记得如何编码它。在我之前的程序员，当许多用户访问相同的文件时，将代码插入备忘录字段以列出用户名和时间戳条目（以及时间），以了解与客户沟通的内容，由谁什么时候。我记不起代码和我到目前为止所尝试过的所有内容，并没有得到我想要的结果。有谁知道如何编写这段代码？

谢谢！它在聚焦上非常有效。 Namistay！

I saw this in a version of Access 2003, but I can''t remember how to "code" it. A programmer before me, had code inserted into the memo field to list the user name and time stamp the entry (with the time as well) when having many users accessing the same files, to know what had been communicated with a customer, by whom and when. I can''t remember the code and everything I''ve tried so far, doesn''t get me the result I want. Does anyone know how to write this code?

解决方案

Private Sub MyMemoField_GotFocus()
Me.MyMemoField = MeMyMemoField.Value & " " & CurrentUser() & " @ " & Now() & " : "
End Sub

It may be better to add this code to the AfterUpdate event rather than every time focus is got.

I saw this in a version of Access 2003, but I can''t remember how to "code" it. A programmer before me, had code inserted into the memo field to list the user name and time stamp the entry (with the time as well) when having many users accessing the same files, to know what had been communicated with a customer, by whom and when. I can''t remember the code and everything I''ve tried so far, doesn''t get me the result I want. Does anyone know how to write this code?

THANK YOU!!! It works very well on "got focus". Namistay!

这篇关于TimeStamping备忘录字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！