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

Hi Al Campagna,
Thanks a lot! your code is really easy to understand and use.

Everything works fine, the DOC and DOLE. But when I do the
=[CurrentUser], it doesn't give me the network logon, but only the Admin
logon. So I'll trying to use the logon code I grabbed from some other
website and let you know the results, or maybe even ask you for more help if
it doesn't work. Thanks again.

Paul.


"Al Campagna" <alcampagna@msnewsgroups> wrote in message
news:%23zZ4Uz0gHHA.4064@xxxxxxxxxxxxxxxxxxxxxxx
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.





.

Quantcast