Hi all,
Had a question about grabbing the workstation logon ID and 1, putting it with a time stamp in a table and then 2, using it to track what changes have been made to the data.
Currently my database opens to a form where people can enter/edit data. This form also pulls the workstation id and puts it in a hidden text field (unbound). I would like to do a "onload" command to put a record in another table (loginhist) of the workstation ID and the time/date stamp that opened it that form. Then once in the form I would like to track that workstation ID's activity (with time/date stamp again). I would like to put this type of info into a table that registers workstation ID, Time/Date, Old Value and New Value.
Unfortunately I have tried Access security but it is now what I am looking for for several reasons. Thus the reason I want to use the workstation ID (which I already have set up).
Not sure if this can happen and if it can not sure where to start. Any leads, answers or alternate ideas would be greatly appreciated.
Thanks
jnp102
Had a question about grabbing the workstation logon ID and 1, putting it with a time stamp in a table and then 2, using it to track what changes have been made to the data.
Currently my database opens to a form where people can enter/edit data. This form also pulls the workstation id and puts it in a hidden text field (unbound). I would like to do a "onload" command to put a record in another table (loginhist) of the workstation ID and the time/date stamp that opened it that form. Then once in the form I would like to track that workstation ID's activity (with time/date stamp again). I would like to put this type of info into a table that registers workstation ID, Time/Date, Old Value and New Value.
Unfortunately I have tried Access security but it is now what I am looking for for several reasons. Thus the reason I want to use the workstation ID (which I already have set up).
Not sure if this can happen and if it can not sure where to start. Any leads, answers or alternate ideas would be greatly appreciated.
Thanks
jnp102