Recording User on Record

[Dunner]

Hey guys,

I was just wondering, is there any way to assign the name
of the user creating a record to a field on the record?
basically so that anyone can look at a record and know
who created it.

Cheers

Dunners

 

[Rick B]

in the default value for your "created" filed, enter

=CurrentUser()


You need to set the field so tha the user can't change it.

You could also place the userid (and date and time) in a timestamp field on
a record by using some code in the "before insert" property.


Rick B

Hey guys,

I was just wondering, is there any way to assign the name
of the user creating a record to a field on the record?
basically so that anyone can look at a record and know
who created it.

Cheers

Dunners

 

[Guest]

Hi Rick,

I've tried that but it says that =CurrentUser() is an
unknown function and won't let me save it. Any ideas on
what this could be?

Thanks for your help

Dunners

 

[Rick B]

Nope. It works fine on the form I just tested.

Rick B


Hi Rick,

I've tried that but it says that =CurrentUser() is an
unknown function and won't let me save it. Any ideas on
what this could be?

Thanks for your help

Dunners

 

[Lynn Trapp]

If you are trying to do it at the table level it won't work. You'll have to
create an input form for your table and put CurrentUser() in the default
value of the control you need it in.

 

[Rick B]

Oooh good catch Lynn.

I had it in my head that we were in a form, and never considered an
alternative.

Thanks!!!

Rick B

If you are trying to do it at the table level it won't work. You'll have to
create an input form for your table and put CurrentUser() in the default
value of the control you need it in.

 

[Lynn Trapp]

It was the Unknown function message that clued me in. Either he is
attempting to do it at the table level or there is a broken reference
somewhere.