Network User Name from VBA to SQL (1 Viewer)

GohDiamond

"Access- Imagineer that!"
Local time
Today, 18:58
Joined
Nov 1, 2006
Messages
550
VBA:
Public Function myNetUSER()
myNetUSER = Environ("username")
End Function

SQL:
SELECT myNetUser() AS NetworkID;

Practical Usage:
SELECT "Profile edited by: " & myNetUser() & " on " & Format(Date(),"m/d/yyyy") AS Authorized;

Result Today:
[ AUTHORIZED ]
Profile edited by: myNetUser on 4/16/2014

Cheers!
Goh
 

Users who are viewing this thread

Top Bottom