Log to show last time/date opened

  • Thread starter Thread starter Opal
  • Start date Start date
O

Opal

I am trying to come up with a solution that will allow me to
show in a text box on my main form in my Access 2003
database when the last time/date the form was opened.

Every Friday I want the database to auto email a report
and thought I could do something on the OnOpen event
but I do not want to email the report every time the
database is opened. I thought if I showed the last
time/date opened then I could use an If - Then statement
to determine if the report had been sent yet or not.

Does anyone have any advice? Thanks.
 
Store the date when you send the report in a table.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)








- Show quoted text -
Click to expand...

So create a "log type" table and store the date/time there
when I send the report?
 
Exactly.

There are other approaches (some people create a database property and store
the data there, some people use an external INI file, some people use the
registry), but putting it in a table is the simplest.
 
Back
Top