Adding date and time to text

[whatdoidonext]

Hi
Apologies first if there is an easy answer to this post as I'm new to Access.

I have a notes box on a form that users update with the latest progress of work done. At the end of each progress I would like Access to automatically add the date, time and user's network id so that I can track who did what and when.

Is there an easy way to code this?

 

[WayneRyan]

What,

Need more info, but generally:

Append to end:

Me.Notes = Me.Notes & vbCrLf & Now() & " " & Me.NetworkID

Append at top:

Me.Notes = Now() " " & Me.NetworkID & vbCrLF & Me.Notes

Wayne

 

[ghudson]

Welcome to the forum!

Searching the forum is a great way to find an answer to your question. Especially the common questions that already numerous threads with similar questions and answers.

You could also incorporate an Audit Trail into your db. Check out the sample I have posted @ Audit Trail.

Use the Environ() function to get their network name.

Environ("UserName")

 

[whatdoidonext]

Many thanks for the response Wayne - it worked a treat.