Capturing Global variable values

L

Larry06Green

How do I write global variable values to a table. I have the following module
which captures the network user id and computername when they log into my
database.

Option Compare Database
Global racf As String
Global wkstation As String

Function GetName()
racf = Environ("username")
wkstation = Environ("computername")
End Function
 
A

AkAlan via AccessMonster.com

This depends on whether you are updating the table or appending it. If you
are updating the try a sql UPDATE command and if you are appending the table
try an INSERT INTO command.
 
Top