How to Run Access Macro in certain times

[OnatGG]

Hello there !

I have my data updated 3 certain times in a day. So i dont want to bother opening the same access 3 times a day. That access can be opened whole day no problem for me. So could u please tell me how to run macros automatically in a time which i determine before ? Thank you !

[pbaldy]

If it was me, I'd create a db that ran your macro when it opened (autoexec) then closed itself. Then I'd call that db from Windows Scheduled Tasks at the appropriate times. If you want to leave the db open, you'd use the timer event of the form and test for the time (it would probably require VBA code). I don't like that because the code is basically always running. I'm stingy with my processor's time.

[OnatGG]

unfourtanently i dont have Windows Scheduled Tasks in my computer. My company doesnt allow it. I thought about a similiar solution like yours already but its no use to me Thx anyway.

[pbaldy]

That seems odd, since it's not really risky in itself. In any case, you use the timer event of the form as mentioned. You probably want form level variables to keep track of whether you've run the process for a particular time, depending on how you test the time. Dive in and post back if you get stuck.

[qa12dx]

use ontimer to close and then open the form. in form on load set your queries to run.
made a quick db. have the time set for 2 seconds. i run the event using time difference betwen 3 seconds. too late in the night to give details, but it is pretty straight forward, maynot be the best way, but here it is for what it worth.

have a look. hope it helps

[OnatGG]

i was on vacation so sorry for late reply. i think ur db is great ! thanks for that ! im a bit newb at access so it ll take some time for me to convert my regular work to this db but its ok since you did what i need. thank you !!

[qa12dx]

cool!