write currentuser in field of a determined table

R

Rui Saraiva

Hi everyone,

I need to create a field in a table of my database that
returns the currentuser which wrote that record. How can i
do it? I have been playing with many options and didn´t
manage to do it.

Thanks in advance
 
C

Chris

Created, or modified the record?

You can put CurrentUser() in the Default Value of the table, or even grab
the User Name from the Windows Login (www.mvps.org/access/api) using
BeforeUpdate events on forms.

--
Chris

Please respond to newsgroups, as I
don't check this address very often.
Hi everyone,

I need to create a field in a table of my database that
returns the currentuser which wrote that record. How can i
do it? I have been playing with many options and didn´t
manage to do it.

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

php mysql code not working on server 2
CurrentUser to update into table field 2
How to default CurUser() into a field in a new record in a Select 4
CurrentUser and WhoOwns 6
currentuser to populate a field 4
Passing the CurrentUser to a field in a table 2
CurrentUser() & workgroup security (ACCESS 2007) 1
Linking the value of a feild to CurrentUser() 1

Top