PC Review


Reply
Thread Tools Rate Thread

Backup the MDB but verifying that the time when closing

 
 
UTOPIAN
Guest
Posts: n/a
 
      21st Apr 2008
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.-
 
Reply With Quote
 
 
 
 
banem2@gmail.com
Guest
Posts: n/a
 
      21st Apr 2008
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
 
Reply With Quote
 
Guest
Posts: n/a
 
      13th Aug 2008

"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.-
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Backup the MDB but verifying that the time when closing UTOPIAN Microsoft Access 2 13th Aug 2008 12:45 AM
Backup the MDB but verifying that the time when closing UTOPIAN Microsoft Access Macros 2 13th Aug 2008 12:45 AM
verifying pst backup =?Utf-8?B?T2tvYm9qaQ==?= Microsoft Outlook Discussion 9 1st Jun 2004 10:53 AM
Verifying Date / Time inputs Rich Microsoft Outlook Form Programming 0 17th Oct 2003 08:41 PM
Verifying Serializable attribute at compile time Mario Garcia Microsoft Dot NET Framework 1 21st Sep 2003 09:28 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:22 PM.