Access to perform action every 10 minutes

[Freedox]

Heya, I'm totally lost here and tried numerous options to achieve this with no success...

So basically I have a button on my Access dashboard that imports EXCEL sheet in the database. I want this "import" action to be performed automatically without someone pushing a button.

I have tried the code below:

Sub my_Procedure()    MsgBox "hello world"        
    Call test ' for starting timer again
End Sub


Sub test()
    Application.OnTime Now + TimeValue("00:10:00"), "my_Procedure"
End Sub

But that is giving me Compile error: Method or data member not found

I have also tried CMD command to run:

"c:\Program Files\Microsoft Office\Office14\MSACCESS.EXE"  "\\MyServer\DB\test.accdb" /X M1

Still had no luck... Anyone know any ways around this??

 

[xenou]

Forms have a timer event:
https://msdn.microsoft.com/en-us/library/bb214858(v=office.12).aspx

That's seems to be what you are after (looks like you tried to use MSExcel code instead in your first example).