tracking which users change records?

[Mike]

I have an access DB and have users login to the database (about 5
users).

I have a table that contains 10 fields that the user enters data via a
form.

Is it possible to add another field and in that field track the
username that added the record?

Mike

[Bob Quintal]

Re: tracking which users change records?

mdrons@yahoo.co m (Mike) wrote in
news:19a14a2c.0 311071809.75386 6ba@posting.goo gle.com:
[color=blue]
> I have an access DB and have users login to the database
> (about 5 users).
>
> I have a table that contains 10 fields that the user enters
> data via a form.
>
> Is it possible to add another field and in that field track
> the username that added the record?
>
> Mike
>[/color]

Yes.

How: set the default value for a hidden textbox on the form, bound
to the field to currentuser().

[Tim Mills-Groninger]

Re: tracking which users change records?


"Mike" <mdrons@yahoo.c om> wrote in message
news:19a14a2c.0 311071809.75386 6ba@posting.goo gle.com...[color=blue]
> I have an access DB and have users login to the database (about 5
> users).
>
> I have a table that contains 10 fields that the user enters data via a
> form.
>
> Is it possible to add another field and in that field track the
> username that added the record?[/color]

There's some code at http://www.mvps.org/access/ that will allow you to
capture the current Windows login. You can add it to the beforeupdate event
on the form

hth,

tim mills-groninger