Making a record of a CommandButtonClick

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

elli - 18 Feb 2006 17:04 GMT

Hi!
I managed to make a button that makes a copy from the database and saves it
somewhere else. Now I'm wondering is there a way to keep track of then it
was last saved....
It overwrites the excisting copy, so there is only one copy at the time...
Any help?

elli

Reply to this Message

fredg - 18 Feb 2006 18:34 GMT

> Hi!
> I managed to make a button that makes a copy from the database and saves it
[quoted text clipped - 4 lines]
>
> elli

If you just want to know the date when the last time the database was
saved, add a table to your database. Add one field:
[LastSaved] DateTime
Name the table tblSavedDate

Code the command button on the form that saves the database (after the
code that actually saves the database runs):

currentDb.Execute "Update tblSavedDate set tblSavedDate =
Date();",dbFailOnError

Add error handling so that you do not update the table unless the
database was successfully saved.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

elli - 18 Feb 2006 19:07 GMT

Thank U very many:))

-e-

"fredg" <fgutkind@example.invalid> kirjoitti
viestissä:mlxcuxdv2s3q$.109tlt2znkro1.dlg@40tude.net...

>> Hi!
>> I managed to make a button that makes a copy from the database and saves
[quoted text clipped - 20 lines]
> Add error handling so that you do not update the table unless the
> database was successfully saved.

Reply to this Message