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
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