Time stamp for record

[marf]

I have a TblProjects and a TblProjectUpdates, linked by ProjectNumber. I
created a form for TblProjectUpdates that users need to update weekly with
progress reports.
The field is called ProjectUpdate...

I would like to have a timestamp, and possibly the network userid of the
person that made the entry.

1. Do I need to have a timestamp and id field in the table that the form
updates?? If so, how do I that?

2. Do I need unbound controls that do not update the table?

Very new at this stuff. Please provide as much detail as you can in your
answer

 

[scubadiver]

For userID I wouldn't know. That would be quite complicated I should think.

In the table you can create a field called updatestamp. In the after update
event for another field you can put the following

updatestamp = now()

That would give you the date and time. Every time the record gets updated
the date and time will change.

Not sure what you are asking in (2)

 

[Douglas J. Steele]

See http://www.mvps.org/access/api/api0008.htm at "The Access Web" for code
to return the Windows Id of the current user. You'd add an UpdatedBy text
field to the table and set it in code just as was suggested for setting
updatestamp.

Note that it's better to set the values in the form's BeforeUpdate event
rather than relying on the AfterUpdate event of a specific field.