users track

[Gerald]

I have 3 users using dbase from network

One text field, I can populate the name of the user in text field by using
=fOSUserName()

but how can I save the name of user who has accessed the record


Thanks

 

[Rob Oldfield]

Depends what you mean by 'accessed'. It's a case of matching the event you
want to trace with what you require. If, for example, you wanted to check
who the last person to view the record was then you could use the form's
Current event, if the last to edit then one of the update events.

Provide some more detail (in a new thread, what exactly do you want to do)
and I'm sure we could come up with an answer.

 

[Gerald]

I want to know who entered the record, by using =fOSUserName(), I can see the
username from the respective computer but from other computer I can see other
user's name.. Somehow I have to save the username who enters the record

appreciate if you could help me

Many thanks

 

[Rob Oldfield]

In that case you need to trap the action of a user actually entering a new
record and set the value at that point. The exact method will depend
on how new records are added but one way would be to have a text box on the
form bound to the field that you want to populate and code like...

me.UserNameTextBoxName=fosusername()

in the after insert event of the form.

 

[Gerald]

Thanks, Rob.

Much appreciated

In that case you need to trap the action of a user actually entering a new
record and set the value at that point. The exact method will depend
on how new records are added but one way would be to have a text box on the
form bound to the field that you want to populate and code like...

me.UserNameTextBoxName=fosusername()

in the after insert event of the form.