Track changes to records

T

TizTIz

I have setup a form that when the users makes changes to a record it will
display the date and time of the change.

I now want to set it up so that it will also show the name of the user who
made change or who added a new recored?
 
M

Masque

This sounds exactly like something I'm looking for, but I'm afraid I don't
understand modules that well....is there a "dumbed-down" version somewhere?
 
S

strive4peace

"show the name of the user who made change or who added a new recored?"

you will need to have a place for the user who changed the record in
your table:

UserChange, text

and a way to identify them. I give each user their own front-end and
store their name in a table. The defaults table has just one record and
the User field will be called UName for this example

on the form eforeUpdate event:

me!UserChange = dFirst("UName", "DefaultTablename")


Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
M

Masque

Brill-i-ant!
Thanks!

strive4peace said:
"show the name of the user who made change or who added a new recored?"

you will need to have a place for the user who changed the record in
your table:

UserChange, text

and a way to identify them. I give each user their own front-end and
store their name in a table. The defaults table has just one record and
the User field will be called UName for this example

on the form eforeUpdate event:

me!UserChange = dFirst("UName", "DefaultTablename")


Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
Click to expand...
 
M

Masque

Hmmmm.....it worked fine for me, but when I updated another user with their
new front-end and modified a record, it said that *I* had done it....?

Obviously I'm missing *some* sort of connection here.....
 
A

Arlene

Please can someone help me with this as I would like to track the history of
every record that is changed by a user. I have a drop down box of all the
users names but am concerned that if a user changes a record multiple times
it is not recorded and can change the record into someone else's name.
 
Top