To know the Windows user id currently logged in, in a text box on an Access form, type =ENVIRON("USERNAME") .
This will work immediately in Access 2000. But if using Access XP, then by default it will error out because the macro security level is set to Medium. To change this, go to the top menu, choose: Tools / Macro / Security / Low.
Thursday, February 17, 2005
Subscribe to:
Post Comments (Atom)
2 comments:
This works for windows login. But do u have any idea to get access users those are defined using security wizard?
CurrentUser()
Post a Comment