Opening Access records date last closed

Z

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top