Have a look at "Creating an Audit Log" by Allen Browne http://www.allenbrowne.com/AppAudit.html
--- In [email protected], "Isaiah Vi" <[EMAIL PROTECTED]> wrote: > > Group, > I have a small Access 2002 db to track projects. I currently have a field (memo type) called status log. I would like a new row to display automatically the date and time-stamp, current user (person entering the information), and the status information. We need this to track history of what has happened so far with a particular project and its current status. The result for each issue would look something like this: > > 06/12/2007 1:45 PM (John Doe): I resolved the issue by compiling the database. > 06/11/2007 3:07 PM (Mary Jane): Waiting to hear back from network staff. > 06/08/2007 9:25 AM (John Doe): Sent Mary a message resolved the issue by compiling the database. > > I'm assuming I will need to create new table and call it something like "tblNotes" and have a subform that displays all of the rows of history. My main question here is how would my query look in order to do the time-stamp with users info stuff as displayed above. Has anyone done something similar in Access and wouldn't mind sharing that bit of code? > > TIA, > Izzy > > > [Non-text portions of this message have been removed] >
