Current User (1 Viewer)

[aftershokk]

Hi, I am using Access 2010 and Windows XP.

I have a form named MasterForm and a subform linked into the MasterForm named history_subform

I am tring to get this to work like in 2003

Set Value Item = [Forms]![MasterForm]![history_subform].[Form]![LastUser]
Expression = GetUser()

Gives me an error that action or function cannot be found by Access....

I could swear this used to work in 2003....

thanks!!

 

[pbaldy]

To my knowledge GetUser is not a built in function. You may be thinking of CurrentUser(), which will return the user if you're using Access Security.

 

[AlexHedley]

You could create your own function and use

=Environ("username")

To get the currently logged in Windows user.

 

[aftershokk]

I just tried currentuser and get this error

You tired to run a vb procedure that improperly references a property or method of an object?

 

[pbaldy]

I've never used it since I don't use Access Security, and it always returns Admin if you don't (are you?). I use the Environ() function Alex mentioned or this:

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

 

[aftershokk]

Is there something wrong with the way I call-out the subform?

Set Value Item = [Forms]![MasterForm]![history_subform].[Form]![LastUser]

nothing seems to work

 

[pbaldy]

Looks correct presuming all the names are correct:

http://www.mvps.org/access/forms/frm0031.htm

That's the subform control's name, not the actual subform's name if they're different?

 

[aftershokk]

The name of the subform is HistorySubForm
and its source is named HistoryForm

The field I am trying to update control source and name is User
thanks

 

[aftershokk]

I got it! thanks!

I used the code from pbaldy via the link!

thanks so much!

 

[pbaldy]

Happy to help!