Run code at certain time 1

[citychap26]

Hi

I know this can be done but just forgotten how.

Say I have an MS Access database 2002. I want to kick off a piece of code at 20:30.

Do I need to create an on timer event on a form to check the current time every 5 mins or so and then once it is 20:30 kick off code? Or is there another way?

Cheers
SK

 

[stephenk1973]

To avoid the the database being open all the time i create a Macro which performed the task and scheduled it in the windows envoiroment. Scheduled task should look something like....

"Msaccess Location" "Database location" /WRKGRP "Security file location" /userUSERNAME /pwdPASSWORD xMACRONAME

/WRKGRP "Security file location" is optional depending on if security has been set up for your database.

e.g.
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Springfield\doh.mdb" /WRKGRP "C:\Springfield\wigam.mdw" /userHomers /pwdSimpson /xCoolReactor

Hope this helps

Stephen

 

[citychap26]

True, it could be scheduled from windows. However I wanted it to be run directly from MS Access.

 

[AlanJordan]

Hi,

I tried this. It works for me:

Private Sub Form_Timer()
Dim varTargetTime As Variant
Dim datNow As Date

varTargetTime = "#" & Me.txtTargetTime.Text & "#"
datNow = Now()
If varTargetTime >= datNow Then
    MsgBox "It's time to go to work"
End If

End Sub

Notes: I created a text box called txtTargetTime.
You might want to use a different logic test
It is necessary to enter a value into the TimerInterval property of the form for this code to execute.

I hope this helps. Alan

 

[AlanJordan]

You could place a button on the form, and turn the Timer On/Off

    Me.TimerInterval = 60000  'milliseconds
or 
Me.TimerInterval = 0

You could also place code in the Form_Load event.

 

[stephenk1973]

I had played with timer functions but found them fiddley and prone to errors. They also relied on the Access database being constantly open and healthy on my PC. If access had accidentally been closed the update would not run. If access had crashed the update would not run. This was a particular problem when i was out of the office for a few days. To solve this i scheduled the macro, but also scheduled a forced reboot an while before.

I found the main advantage of using the Windows scheduler was i didn't have to write my own. I'm not sure if you can create a task from Access but would intrested to see it posted back if it can be done.


All the best

Stephen

 

[mp9]

Alternatively, try the Handy Access Launcher (HAL) for scheduling Access admin tasks like macro runs, compacts, repairs, etc. If your function resides in an Access db then HAL could be used to schedule it's execution via a macro - take a look at

http://www22.brinkster.com/accessory/resources/001.shtml