Capturing Global variable values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Larry06Green - 13 May 2008 16:10 GMT

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

Reply to this Message

AkAlan - 13 May 2008 17:27 GMT

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.

>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
[quoted text clipped - 8 lines]
>wkstation = Environ("computername")
>End Function

Reply to this Message