current user

[Kay]

Hi Guys

I have created a single database that resides on one computer. The
database has about 11 users which I have created using the ms access
security feature so that each user has to login with their own name and
password.

In my table I have a field called user which is represented by a text
box on my form. When storing a record I want to display the user who
first stored that particular record. I am using access 2000 and the
currentuser() in the text box does not seem to work

Any help will be appreciated

[Larry Linson]

A Field defined in the Record with =CurrentUser() as its Default Value has
worked for me. That is only updated when the record is created... it won't
be "user who last updated".

What do you mean "the currentuser() in the textbox"? If you clarify, someone
may be able to make a useful suggestion.

Larry Linson
Microsoft Access MVP

"Kay" <kh******@hotmail.com> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.com...

Hi Guys

I have created a single database that resides on one computer. The
database has about 11 users which I have created using the ms access
security feature so that each user has to login with their own name and
password.

In my table I have a field called user which is represented by a text
box on my form. When storing a record I want to display the user who
first stored that particular record. I am using access 2000 and the
currentuser() in the text box does not seem to work

Any help will be appreciated

[Anthony England]

"Kay" <kh******@hotmail.com> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.com...

Hi Guys

I have created a single database that resides on one computer. The
database has about 11 users which I have created using the ms access
security feature so that each user has to login with their own name and
password.

In my table I have a field called user which is represented by a text
box on my form. When storing a record I want to display the user who
first stored that particular record. I am using access 2000 and the
currentuser() in the text box does not seem to work

Any help will be appreciated

You should be able to put
=CurrentUser()
in the Default Value property of the textbox.

[Kay]

Im going to mess about with it a bit furthur but what I meant was I
entered currentuser() in the control source property of the text box

[Kay]

Guys, Ivetried that but it works for an unbound field only. On a bound
field it comes up as 0

Any suggestions please

[DeanL]

I had a problem similar to this using CurrentUser() and for some
reason, the text boxes just would not update after the relevant field
was updated so I used:

AfterUpdate

txtBox = CurrentUser

minus the brackets and I've never had a problem since then. I found
the reason for this was that the DB didn't like updating the textbox
when another control was the focus for the AfterUpdate event and this
was pointed out to me in ths group. Hope this helps

[Kay]

Thanks dean, but this will update the field continuously but I need to
store the name of the user who saved that particular record. If another
user logs in and saves another record, I want to have the other users
name stored in the user field for the other record

[DeanL]

Sorry Kay,

I created a User field in the relevant table and used the above process
to record who made changes against a particular record. I display this
on the form using a text box and by storing the Username in a field the
CurrentUser function applies only to the specific record that the user
is updating/changing.

Hope I haven't confused you on this (as I usually end up confusing
myself).

D...

[Kay]

Crystal Clear, Thanks alot dean Im just gona start playing about with
it for a moment and hope to get it working,

[Anthony England]

"Kay" <kh******@hotmail.com> wrote in message
news:11********************@z34g2000cwc.googlegrou ps.com...

Crystal Clear, Thanks alot dean Im just gona start playing about with
it for a moment and hope to get it working,

I am 100% sure this works.
However, I know that Access forms can become confused when you are working
with them - and in the worst case they can become irreversibly corrupted.
However, it might not be that bad.
Make sure that your field and textbox names are different:
For example, the field in the table is CreatedBy the textbox name is
txtCreatedBy and the default value is =CurrentUser()

If this is still not working, just take 30 seconds to create the most basic
of forms bound to the table, just to verify that what we are telling you
should (and normally does) work.

[Kay]

Thats a very good tip, I created another table and a form and put a
bound field in the form and the same currentuser() code in the default
value of the field works. It must be something wrong with my db

[Kay]

THANKYOU all for your help, I have got it to work. I feel very thick at
this moment because I just clicked the add button and realised that the
user field changed to the current user Doh! Thats all it took

[Anthony England]

"Kay" <kh******@hotmail.com> wrote in message
news:11*********************@j52g2000cwj.googlegro ups.com...

THANKYOU all for your help, I have got it to work. I feel very thick at
this moment because I just clicked the add button and realised that the
user field changed to the current user Doh! Thats all it took

Doh!