Log to show last time/date opened

[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.

 

[Douglas J. Steele]

Store the date when you send the report in a table.

 

[Opal]

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 -

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

 

[Douglas J. Steele]

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.