Extract the user into a table (1 Viewer)

ECEK

Registered User.
Local time
Today, 03:57
Joined
Dec 19, 2012
Messages
717
I am working on a network where the user of Access is logged in.

I want to extract this user into a table.

I would then be able to relate this to a table of permissions in the database.

How would I go about this?

Thanks for your time in advance
 

ECEK

Registered User.
Local time
Today, 03:57
Joined
Dec 19, 2012
Messages
717
I've got my name in the top right hand corner but if I use:

= CurrentUser()

It returns Admin

I'm looking to get my name
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 10:57
Joined
May 7, 2009
Messages
19,246
use

=environ("username")
 

ECEK

Registered User.
Local time
Today, 03:57
Joined
Dec 19, 2012
Messages
717
Hi Arnelgp

I get #Name? when I use =environ("username") ?
 

Users who are viewing this thread

Top Bottom