Run a Queery on a schedule time

[CharlesCount]

Can I set up an append query to run at preschedule time every day of the week?
Thanks
CharlesCount

[Tom van Stiphout]

On Fri, 06 Jul 2007 02:45:59 GMT, "CharlesCount" <u35616@uwewrote:

I just answered a very similar question the other day.
Groups.google.com is a great resource.
The answer: Yes.
Use the Windows Scheduler to schedule this command line:
<path to>msaccess.exe <path to>your.mdb /x YourMacro
This macro would run your append query.

-Tom.

>Can I set up an append query to run at preschedule time every day of the week?
Thanks
CharlesCount

[Max Vit]

It can be done within access too.

Here is some sample code I used before; this code requires access to
be running to be executed.

Sub Form_Load()
Me.TimerInterval = 1 * 60 * 1000
'60000 = 1 Minutes
'The above to check your computer's clock every 1 minute
End Sub

Sub Form_Timer()
Dim MyTime As Variant

MyTime = Time

If MyTime >= TimeSerial([Forms]![Main]![HR], [Forms]![Main]![MN], 0)
Then

'In a form, place couple of boxes to indicate the time in hours (text
box HR)
'and in minutes (text box MN) - so you enter 20 in HR and 15 in MN for
this
'action to be triggered at 08:15 PM

Me.TimerInterval = 0

DoCmd.RunSQL "DELETE [OH Aus].* FROM [OH Aus];"
'The above deletes data using SQL statements
DoCmd.OpenQuery "On Hand Aus", acNormal, acEdit
'The above appends data running an MS Access action query

DoCmd.Quit
'This to quit the application if this is what you want to do after
the set time
End Sub