S smvpegb Joined Dec 19, 2007 Messages 3 Reaction score 0 Jan 9, 2008 #1 Hi to all, I've a table and i want to save a field in automatic the windows user's name or the PC Name , can you please help me with this!!! thanks a lot Gene
Hi to all, I've a table and i want to save a field in automatic the windows user's name or the PC Name , can you please help me with this!!! thanks a lot Gene
O orange Joined Dec 17, 2007 Messages 57 Reaction score 0 Jan 14, 2008 #2 You can use the following to see various Environment variable values in Access 2003. For i = 1 To 31 z = Environ(i) Debug.Print i; z Next i when i = 6 you get the ComputerName 6 COMPUTERNAME=HOME-6399619597 when i = 28 you get the User name 28 USERNAME=user
You can use the following to see various Environment variable values in Access 2003. For i = 1 To 31 z = Environ(i) Debug.Print i; z Next i when i = 6 you get the ComputerName 6 COMPUTERNAME=HOME-6399619597 when i = 28 you get the User name 28 USERNAME=user
