Time Stamp Record Changes

[ksaab]

I have done this in the past but it has been sooo long since I consistently used Access that I am in a fog

How can I create a timestamp or series thereof, so that each time data is added to a Memo field there is a date time record created? My goal is to allow people to enter notes but have the timestamp automatically either append itself to the note OR timestamp a seperate field? Open to ideas...

Thanks much!

 

[Sergeant]

Use a text box for them to enter new text.
Use a button "Add"...

Me.txtMyMemoControlName = Now() & " - " & txtMyTextBox & vbCrLf & Me.txtMyMemoControlName

This will keep new entries at the top. You can probably work out how to put them at the bottom.

 

[ksaab]

Would this be applicable to a memo field? The idea is that I would like it to create a stamp before or after each addition to the Memo field...

Thanks!

 

[Sergeant]

Yes. The way I suggest would have the memo control locked or hidden, and you'd use an unbound textbox and button to add entries to it.

 

[ksaab]

Works great! Thanks!!!

 

[Sergeant]

Kool! I love a success story.

 

[ghudson]

How about using an Audit Trail

 

[ClayMac]

Use a text box for them to enter new text.
Use a button "Add"...

Me.txtMyMemoControlName = Now() & " - " & txtMyTextBox & vbCrLf & Me.txtMyMemoControlName

This will keep new entries at the top. You can probably work out how to put them at the bottom.

I am a newbie to coding in Access. Where would you store this code? What is "Me."?

Grateful for any advice.

Many Thanks

Clay

Marketing at Xerox UK

 

[Sergeant]

Put button on form.
Show properties for button.
Select EVENT tab.
To the right of "CLick", select 'event procedure'.
Click the three dots next to that block. (code window opens with sub defined)
Write code in space provided.

"Me" could be better explained by someone with more experience, but...
It's like defining the context of an object, property or action. If the code is in the form's class module, "Me" means "this form" (more or less).

 

[ClayMac]

Thank you very much indeed. It really works very well. It is amazing how powerful how just one line of code is in Access.

Many thanks

Clay