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

Hi Al Campagna,
Thanks for your fast respond but I'm a little confused. But I took what
you said and created two buttons, one for viewing only, which everyone can
view, another one is for add/edit, providing that their user name is already
in my user name table to allow them to click on this button. The View only
is easy, I just create a Macro with the view option. And I created another
Macro to open the form in Add mode, but no edit mode. And right now
everyone can click on this add/edit mode. So I'm trying to make this
database so that only the user who added a record can edit that record but
no one else. And also only a limited number of users are allowed to add
records. Thanks again.
Paul.
"Al Campagna" <alcampagna@ msnewsgroups> wrote in message
news:uUuAdvNhHHA.2640@xxxxxxxxxxxxxxxxxxxxxxx
Paul,
Well, the LUE is really meant, like DOLE, to change each time someone
else edits an existing record. So, perhaps a name like RC (record
creator) would be more appropriate, and... like DOC, the value is set at
creation time, and never changes.
You should be able to use your form query to set the RC criteria to...
=[CurrentUser]
That should create a recordset for that CurrentUser of only records with
RC= CurrentUser.

Probably you'll need a separate form for "new" records, since new
records have no RC at query time, no one could enter a new record. That
could just be an exact copy of your editing form, but with no RC criteria,
and the form's DataEntry set to Yes.

Not sure what you're doing with the TempLue. I wouldn't think that
would be needed...

--
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:loAWh.12272$Kd3.729@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Al Campagna,
Thanks for the help again. Everything works so far so good regarding
the previous questions I have. So here's what I am able to do:
Capturing the DOC, DOLE, and LUE. But I have one more problem that i've
been trying all day but no luck. I want my database to allow the user
who added a record be able to edit that record but no one else. But in
viewing mode, everyone can view all records. So I'm taking this one step
at a time. I'm currently working on only the user who added the record
be allowed to modified that record. So my Record form is based on a
query. And this what I have so far:

Name
Address
DOC
DOLE
LUE
TempLUE = temp value of fOSUserName()

and I want when my form opens, the query would only select records that
the LUE = TempLUE. TempLUE is a temp value that's copied from
fOSUserName.
But i'm having the problem of getting my form to run this query when it
opens.
Thanks.
Paul.

"Al Campagna" <alcampagna@msnewsgroups> wrote in message
news:u1%23yim8gHHA.4596@xxxxxxxxxxxxxxxxxxxxxxx
Paul,
You'll be using an API call to the operating system for that value.
Try this...
http://www.mvps.org/access/api/api0008.htm

--
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:9WeWh.12168$Kd3.6433@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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.













.