Recording User on Record

  • Thread starter Thread starter Dunner
  • Start date Start date
D

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
 
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
 
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
 
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
 
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.
 
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.
 
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.
 
Back
Top