User who just logged in (1 Viewer)

G

grnzbra

Registered User.

Local time

Today, 20:15

Joined

Dec 5, 2001

Messages

376

• Aug 31, 2006

• #1

In an network environment that requires users to log in, is there any way for Access to record a user who opens an Access application. The application has no security applied to it. The .ldb has the users listed, but can the .mdb put it into a list inside the .mdb?

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 12:15

Joined

Aug 30, 2003

Messages

36,125

• Aug 31, 2006

• #2

Search here on Environ(), and there's also:

http://www.mvps.org/access/api/api0008.htm

 

G

grnzbra

Registered User.

Local time

Today, 20:15

Joined

Dec 5, 2001

Messages

376

• Aug 31, 2006

• #3

Thanks. That's just what I was looking for.

One quick question. It takes "username". What else can it take. The help files have chosen not to list available arguments.

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 12:15

Joined

Aug 30, 2003

Messages

36,125

• Aug 31, 2006

• #4

Here's a way to get them all for yourself. You might change the max of x to see if your environment returns more. That's how many mine had:

Code:Copy to clipboard

  Dim x                As Integer
  For x = 1 To 31
    Debug.Print Environ(x)
  Next x

The value to the left is the text you would type into the formula, the value to the right is what it returns on your PC.