capture username() on form

4 May 2006 4:46 AM

babs

I have a field calle user in a table, on the form have the user field. Would
like to tie it to an Event (Oncurrent) of form makes it look okay when

I have a field in the table called user but not sure what else to do. - not
sure what to attach it to or the exact code.

user=currentuser()

attached it to the before updat of the form - don't want the user to change
if just navigate with buttons through records and not changing data . if
data changed in record or record added want the new user captured.

didn't work on on current event of form either

thanks for helping

4 May 2006 11:35 AM

Lynn Trapp

Put this in the before update event of the form.

Me.User = CurrentUser()

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

Show quoteHide quote

"babs" <b***@discussions.microsoft.com> wrote in message
news:83D120DC-CEF9-4671-BC95-52F356BF8CE3@microsoft.com...
>I have a field calle user in a table, on the form have the user field.
>Would
> like to tie it to an Event (Oncurrent) of form makes it look okay when
>
> I have a field in the table called user but not sure what else to do. -
> not
> sure what to attach it to or the exact code.
>
> user=currentuser()
>
> attached it to the before updat of the form - don't want the user to
> change
> if just navigate with buttons through records and not changing data . if
> data changed in record or record added want the new user captured.
>
> didn't work on on current event of form either
>
> thanks for helping
>
>

4 May 2006 4:24 PM

babs

When I first come back into the form and Navigate forward (1 to 2) under a
different user I can see the username is set to who put the record in.(or who
looked at it last). Then when I navigate back it gets reset to the present
user. I don't want the username to change if a new person is just navigating
through the records??? Any ideas.

thanks,
Barb

Show quoteHide quote

"Lynn Trapp" wrote:

> Put this in the before update event of the form.
>
> Me.User = CurrentUser()
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
> Jeff Conrad's Access Junkie List:
> http://home.bendbroadband.com/conradsystems/accessjunkie.html
>
>
>
> "babs" <b***@discussions.microsoft.com> wrote in message
> news:83D120DC-CEF9-4671-BC95-52F356BF8CE3@microsoft.com...
> >I have a field calle user in a table, on the form have the user field.
> >Would
> > like to tie it to an Event (Oncurrent) of form makes it look okay when
> >
> > I have a field in the table called user but not sure what else to do. -
> > not
> > sure what to attach it to or the exact code.
> >
> > user=currentuser()
> >
> > attached it to the before updat of the form - don't want the user to
> > change
> > if just navigate with buttons through records and not changing data . if
> > data changed in record or record added want the new user captured.
> >
> > didn't work on on current event of form either
> >
> > thanks for helping
> >
> >
>
>
>

4 May 2006 4:50 PM

Lynn Trapp

Do you also have that code in the Current event of the form?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

Show quoteHide quote

"babs" <b***@discussions.microsoft.com> wrote in message
news:C82FA6F0-5E93-4423-BDBF-B094AD3EB7F2@microsoft.com...
> When I first come back into the form and Navigate forward (1 to 2) under a
> different user I can see the username is set to who put the record in.(or
> who
> looked at it last). Then when I navigate back it gets reset to the
> present
> user. I don't want the username to change if a new person is just
> navigating
> through the records??? Any ideas.
>
> thanks,
> Barb
>
> "Lynn Trapp" wrote:
>
>> Put this in the before update event of the form.
>>
>> Me.User = CurrentUser()
>>
>> --
>> Lynn Trapp
>> MS Access MVP
>> www.ltcomputerdesigns.com
>> Access Security: www.ltcomputerdesigns.com/Security.htm
>> Jeff Conrad's Access Junkie List:
>> http://home.bendbroadband.com/conradsystems/accessjunkie.html
>>
>>
>>
>> "babs" <b***@discussions.microsoft.com> wrote in message
>> news:83D120DC-CEF9-4671-BC95-52F356BF8CE3@microsoft.com...
>> >I have a field calle user in a table, on the form have the user field.
>> >Would
>> > like to tie it to an Event (Oncurrent) of form makes it look okay when
>> >
>> > I have a field in the table called user but not sure what else to do. -
>> > not
>> > sure what to attach it to or the exact code.
>> >
>> > user=currentuser()
>> >
>> > attached it to the before updat of the form - don't want the user to
>> > change
>> > if just navigate with buttons through records and not changing data .
>> > if
>> > data changed in record or record added want the new user captured.
>> >
>> > didn't work on on current event of form either
>> >
>> > thanks for helping
>> >
>> >
>>
>>
>>

4 May 2006 11:55 AM

Keith Wilby

Show quote Hide quote

"babs" <b***@discussions.microsoft.com> wrote in message
news:83D120DC-CEF9-4671-BC95-52F356BF8CE3@microsoft.com...
>I have a field calle user in a table, on the form have the user field.
>Would
> like to tie it to an Event (Oncurrent) of form makes it look okay when
>
> I have a field in the table called user but not sure what else to do. -
> not
> sure what to attach it to or the exact code.
>
> user=currentuser()
>
> attached it to the before updat of the form - don't want the user to
> change
> if just navigate with buttons through records and not changing data . if
> data changed in record or record added want the new user captured.
>
> didn't work on on current event of form either
>
> thanks for helping
>
>

This was answered for you in microsoft.public.access.forms. Please
crosspost, not multi-post.

Keith.