Hi all!!

How do I make that:

When closing the mdb do the following:

Backup the mdb, but verifying that the time is >= at 13: 00 hr.???


Thanks!!!

Utopian.-

On Apr 21, 1:10*am, "UTOPIAN" <gla1...@yahoo.com.ar> wrote:
> Hi all!!
>
> How do I make that:
>
> When closing the mdb do the following:
>
> Backup the mdb, but verifying that the time is >= at 13: 00 hr.???
>
> Thanks!!!
>
> Utopian.-

Simple solution is to create one empty form which you will open as
hidden when DB loads. When this form closes (that can happen only when
the DB is closed) you can run code on OnClose event:

If Time() >= "13:00:00" Then
FileCopy "YourDB.mdb", "BackOfYourDB.mdb"
End If

Depending on the code you already have to backup your database, please
change second line of the code above.

Note that time "resets" at midnight so each time between 13:00 and
24:00 will run the FileCopy line.

Regards,
Branislav Mihaljev, Microsoft Access MVP

"UTOPIAN" <(E-Mail Removed)> a écrit dans le message de groupe de discussion : C3E5D3B1-0738-4548-A39A-(E-Mail Removed)...
Hi all!!

How do I make that:

When closing the mdb do the following:

Backup the mdb, but verifying that the time is >= at 13: 00 hr.???


Thanks!!!

Utopian.-