Appending to text

[jimleon]

I have a form for inputting notes which has a submit button. When the button is clicked I need a copy of what was typed appended to the top of a log. All works fine there. However to increase tracability i also want to append the username and date/time the note was created. The date is easy but how do I retrieve the windows username ?? I'm using office 2003

Thanks in advance

[ADezii]

I have a form for inputting notes which has a submit button. When the button is clicked I need a copy of what was typed appended to the top of a log. All works fine there. However to increase tracability i also want to append the username and date/time the note was created. The date is easy but how do I retrieve the windows username ?? I'm using office 2003

Thanks in advance

A simple API Call will enable you to retrieve the Window's User Name as in:

1. Declare this Function Publically in a Standard Code Module.
   

   Public Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long

2. Retrieve the value via the illustrated code below.
   

   Dim lngLength As Long, strUserName As String, lngRetVal As Long
    
   strUserName = String$(254, 0)
   lngLength = 255
    
   lngRetVal = GetUserName(strUserName, lngLength)
    
   strUserName = Left$(strUserName, lngLength - 1)
    
   'value now contained in strUserName
   Debug.Print "The Current Windows User is " & strUserName

OUTPUT:

The Current Windows User is Armund P

[missinglinq]

I've used this before:

CurrentUser() & " @ " & Now()

which yields

Linq @ 7/19/07 9:53:24 PM

Good Luck!

Linq ;0)>

[jimleon]

Cheers mate, it worked a treat!

I've used this before:

CurrentUser() & " @ " & Now()

which yields

Linq @ 7/19/07 9:53:24 PM

Good Luck!

Linq ;0)>

[ADezii]

I have a form for inputting notes which has a submit button. When the button is clicked I need a copy of what was typed appended to the top of a log. All works fine there. However to increase tracability i also want to append the username and date/time the note was created. The date is easy but how do I retrieve the windows username ?? I'm using office 2003

Thanks in advance

The date is easy but how do I retrieve the windows username ??

Be advised that CurrentUser() will not retrieve the User's Name who is logged on to Windows but will return the Current User of the Database.

[missinglinq]

If you want to know the person who just made an entry in the database, wouldn't that be the Current User of the Database as opposed to the person who booted up Windows?

[jimleon]

Actually, its always returns 'Admin' on every workstation it is run on!

[jimleon]

OK, so it looks like I have to use this bit of code but can't find when to put the declaration statement.

A simple API Call will enable you to retrieve the Window's User Name as in:

1. Declare this Function Publically in a Standard Code Module.
   

   Public Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long

2. Retrieve the value via the illustrated code below.
   

   Dim lngLength As Long, strUserName As String, lngRetVal As Long
    
   strUserName = String$(254, 0)
   lngLength = 255
    
   lngRetVal = GetUserName(strUserName, lngLength)
    
   strUserName = Left$(strUserName, lngLength - 1)
    
   'value now contained in strUserName
   Debug.Print "The Current Windows User is " & strUserName

OUTPUT:

The Current Windows User is Armund P

[ADezii]

OK, so it looks like I have to use this bit of code but can't find when to put the declaration statement.

OK, so it looks like I have to use this bit of code but can't find when to put the declaration statement.

As indicated in Item #1 from the Response, in a Standard Code Module.

1. Select the Modules Tab in the Database Window.
2. New.
3. With (General) visible in the left drop down, and (Declarations) visible in the right drop down, paste the Function Declaration.

[ADezii]

If you want to know the person who just made an entry in the database, wouldn't that be the Current User of the Database as opposed to the person who booted up Windows?

Your logic is sound, ling but I was simply responding to the OP's request.

The date is easy but how do I retrieve the windows username ??