Clear out file based on time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mat - 06 Jan 2005 16:31 GMT

Hi

How do you run a procedure that activates at a set time?
I want to run a procedure that moves a log file to an
archive directory at midnight (or at anytime after this
when the PC is next turned on).
Thanks for any help...
Mat

Reply to this Message

Roxie Aho - 06 Jan 2005 19:27 GMT

> Hi
>
[quoted text clipped - 4 lines]
> Thanks for any help...
> Mat

This newsgroup is for users of the Microsoft Access database software.
You'll probably get more help in one of the Windows newsgroups.

However, from the sound of your question, you already have the procedure
written and just neet to run it on a schedule. Try Scheduled Tasks. In
Windows 2000 you can find it under Accessories, System Tools. It may be
elsewhere in other versions.

Roxie Aho
roxiea at usinternet.com

Reply to this Message

Alex Ivanov - 06 Jan 2005 19:33 GMT

Use Windows Task Scheduler (Control Panel/Scheduled Tasks on WinXP)

BTW this is a group dedicated to Microsoft Access, a database product.

Signature

Please reply to NG only. This email is not monitored.
Alex.

> Hi
>
[quoted text clipped - 4 lines]
> Thanks for any help...
> Mat

Reply to this Message

Mat - 06 Jan 2005 20:18 GMT

Sorry, Perhaps I was not clear in original post.
I have an Access database that uses an external log file
to retrieve some data (eg date, email address, etc).
I want to be able to use VBA to archive the old log file
at midnight - or anytime after the next time the PC is
turned on. It will delete the original and then recreate
a new one.
I have the code to do the actual creation/deletion/move -
I am not sure about how the time part would be best
coded ?

Any ideas ...

>-----Original Message-----
>Use Windows Task Scheduler (Control Panel/Scheduled Tasks on WinXP)
[quoted text clipped - 11 lines]
>
>.

Reply to this Message