Retrieve Username

[slweiser]

I have an CommentUnbound and Comment field. The Comment Unbound updates the
Comment memo field. BeforeUpdate in the Comment field posts a date/time
stamp. I now would like to have the Username (from the network) to follow
immediately after the date time stamp. An Example followsof the
date/timestamp in the Comment memo field:

4/4/2009 12:28:37 AM
Now will it go to the next record

4/4/2009 12:26:04 AM
Testing next record by Click
-----------------------------------------------------------------------------
---

My code looks like this:


Private Sub Comment_BeforeUpdate(Cancel As Integer)

End Sub

Private Sub CommentUnbound_AfterUpdate()

Me.Comment = vbCrLf & vbCrLf & Now() & vbCrLf & Me.CommentUnbound & " " & Me.
Comment

Me.CommentUnbound = vbNullString

End Sub
'date stamps, advances 2 lines and carriage return on exit of Comment memo
field.
------------------------------------------------------------------------------

 

[Stefan Hoffmann]

hi,

Is there an easy way to add the username to the BeforeUpdate event. I have
read and tried to use the code on http://www.mvps.org/access/api/api0008.htm.
but with now success.

As I don't see the function call to fOSUserName(), what have your tried
so far?



mfG
--> stefan <--

 

[slweiser via AccessMonster.com]

see my reply to Erez. for more details

hi,

As I don't see the function call to fOSUserName(), what have your tried
so far?

mfG
--> stefan <--