Inserting time and date on start-up and shut-down

[zeeforel]

Hi there,

Can anyone please explain me how to have Access 97 insert (in a table) a current date and time on starting-up access and shutting it down again? Can that be automated? What if I have an intermediate computer crash?

I want to use the information as a log for the time I have worked during the day.

Many thanks for your information!

Best regards,

Marcel

 

[sfreeman@co.mer]

Many ways to do this... one way:

Create a dummy form that opens via an autoexec macro upon startup, and set the OnOpen event to insert the date/time into the log in field in your log table, and then sets its visible property to no. In fact, just design the form so that it is always invisible.

Leave the form open, but invisible at all times. In the form's OnClose event, run the same code, but insert it into the log out field of the log table.

No?

HTH

 

[zeeforel]

Thanks!!

HTH,

Thanks very much. I will certainly try this.

Marcel