network users

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All,

I have a database on my computer which is shared by 5 users via lan
network.. I mapped my drive/foler/database path onto their system. works
fine. ok so far, I can say.

my question. I want to know how will I track how many policies been entered
by each user. No manual intervenion needed.
e.g.
a textbox which will display the name of user when logged from his system or
even when update done on any policy

hope its not difficult

Thanks

Gerald
 
It looks more complicated than it is (you don't have to understand how it
works, just use it!) - but those nice guys as mvps have done it for you
(several ways, of which here is one example)

http://www.mvps.org/access/api/api0008.htm

all you do is copy the relevant code into a new module, then on the on open
properties of the relevant form, run the code and set the default

then have an invisible field on the record, and update this whenever a
record is updated or added to put the username in here.
 
I copied the code in the module, now how do I run the code. sorry Imight
sound bit novice in these, but I think I am bit lost here.
 
Hi Jack,

This is what I wrote under the form which needs to track the users who has
added or made changes in records

Private Sub Form_Open(Cancel As Integer)
USERSNETWORK.fOSUserName
End Sub

I have a invisible field name usersupdate, now next ???? plz guide

Thanks
 
Back
Top