Opening Access records date last closed

[Zen]

Hi
When Access 2003 closes I would like it to record the date and time it was
closed in a time/Date field on the first page that opens (Main Switchboard)
so that I can tell when it was last closed. I have a Exit button on Main
Switchboard to close and exit the database. I only understand a little about
VB and mainly use wizards to create everything for me.
Thanks in advance

 

[John W. Vinson]

Hi
When Access 2003 closes I would like it to record the date and time it was
closed in a time/Date field on the first page that opens (Main Switchboard)
so that I can tell when it was last closed. I have a Exit button on Main
Switchboard to close and exit the database. I only understand a little about
VB and mainly use wizards to create everything for me.
Thanks in advance

You'll need to store this value in a Table (well, there are other ways but
this is by far the simplest). You could have a simple little one-row table
with a date/time field and in the Exit button's click event set the field to
Now(). If the switchboard is not bound to a table, you could simply bind it to
this and have a textbox bound to the field.