Re: Keeping Tracking of who's adding new data..

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Paul,
On my website, I have a sample A97 and A2003 file called Record Statistics, that
demonstrates how to know the Date of Creation (DOC) od a record, and the Date Of Last Edit
(DOLE).
You could add a field to your table called LEU (Last Edit User) that works just like my
DOLE, but capturing the [CurrentUser] system variable.
LEU = [CurrentUser]

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

"Paul" <yournumberplease@xxxxxxxxxxxxx> wrote in message
news:OXXVh.17255$JZ3.11589@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello All,
I have a huge database with a lot of users...I have input a procedure that i got from
online to figure out which network user is loging in and using the form...is there a way
i can create another column in my table to capture each time this user added a record or
last edited a record? Thanks and if you need the procedure than I can paste it on here.
Thanks again.



.