Question Date stamping on exit

[Croco]

Hi, Iam sure there is a simple explanation for this issue.

I would like to know if is possible for a date to be stamped into record when a person closes an mdb. The purpose would be for a query to be made against this date to say the current date to determine if any new information has been recorded since the last time the mdb was accessed by a particular user. Or is there a simpler way of looking at this notion.

helped before


croco

 

[Banana]

If all you want is a per-session timestamp, you probably could use a hidden form as the startup form which would then open your actual form and stamp the time when the file was opened. When your user closes the application normally, the form's close event will be triggered and you can use that to create a timestamp of when the user exited the application.

Be aware though:

1) It won't work for abnormal exiting (e.g. crashing) but you can infer this from an absence of timestamp for exiting between two actual timestamps for opening the file.

2) I'm not sure what you hope to gain from this. If it has to do with maintaining data integrity or auditing the changes, then I would think that per-row stamping would make more sense than per-session. Search for "audit trails".

 

[Croco]

Thanks Banana, I think you have given a good range of options with which to progress. The hidden form may well be the way to go. In any event I shall have a wander around "sudit trails' as you suggest.

Croco