Add identifying Information for User actions that took place.

[dmcmillo]

I don't know if this can be done. I'm using Access 2010 and I have users updating information on a hourly basis.


Can I have a field that basically shows the last user that edited the form or saved it?

[June7]

Do you mean last user that edited the record?

Is this db on a network file server? Can pull the username from the network with Environ("USERNAME").

Or have a login procedure for the db.

[dmcmillo]

Do you mean last user that edited the record?

Is this db on a network file server? Can pull the username from the network with Environ("USERNAME").

Or have a login procedure for the db.

Yes the last user that edited the record.
Right now its in my personal folder until ready to be deployed. I assume so it could pull it. I have not had to do that with any other db Ive created so far.

I have a login procedure for a couple other db, adding it to this one would really be a pain for the user. Kinda need very quick access several times an hour. (my view. like if you have a bookmarks for windows browser.)

[June7]

I have a db where I need to document the user in some records. I have a table of users with their network username and their initials. I use their initials to document user in record. However, I use the Environ() function to pull their network username and do a lookup on the table to get their initials. Users do not have to 'login' to db.

What happens several times an hour that you would need to do this?

[dmcmillo]

request from outside vendors. internal vendors, graphics changes, approvals, rejections, projection (ton) etc the list goes on.

1.Ok so i can create a table with all user network names and initials.
2.Create a field for the user name to appear (Do i use the lookup function here and not just a textbox?)
3. Add field to each form needed and add the the Environ() function to the code after update?

[NTC]

Continuing with what you have already via J7:
You need to add the User and Date fields to the tables that contain the data that you want tracked.
Then you need to get creative as to when you are going to trigger the write - perhaps the OnDirty event....this depends on your knowledge of the user's behavior
The timestamp can just be Now() while the User info is called from somewhere as per the dialog with J7.

Whether or not you display these fields in the user's form is up to you - but put them in the form in order to facilitate the write task - and have visible during development so that you can eyeball that things are working...and then ultimately you can make them not visible if you wish.

[June7]

It's just a textbox and would be set not to allow user edit. As NTC says, it can even be hidden from users if you want. And as also noted, the real trick is figuring out what event(s) to put code in.