Auto execution

  • Thread starter Thread starter JA
  • Start date Start date
J

JA

I have MS Access macros which I want to run everyday at
7:00 AM. How can I do this? Please help!
 
You can either use windows task scheduler to run access with your database,
or if access always loaded - make a new form, which always loaded, set it
timer event to check for 7:00 AM (using Now() function) and then run your
macro using Docmd.runmacro.
 
I have MS Access macros which I want to run everyday at
7:00 AM. How can I do this? Please help!
Click to expand...

does your App run 24 hours?
if yes use a form-timer with intervall: 60000
in the timer event:
if hour(now)=7 and min(now)=0 then
run your macro
endif

else
use the scheduled task from windows to run a mdb
which autoexec is using the makro and the original mdb
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table macro filter data between yesterday and today (date+time) 0
Help with vba autorunning macro? 2
Using FLAG 3
Access Making a memo in Access 0
copy data from one excel workbook to another workbook using macro 4
Access Access 2010 - Date()-1 and times in query 0
Elapsed time with only 1 column 3
Running a macro based on the time 1

Back
Top