How make a specificmaro runs in a specifictime?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dears,

Kindly i need your support to advise me about making a specific macro runs
in a specific time, and if i cane do it whithout using VBA.
 
Hi

Use the Windows scheduler to run the following...

"c:\full path...\msaccess.exe" "full path and filename.mdb" /x MacroName

If you want Access to close again after running the macro then add a Quit
action as the last line of the macro.

hth

Andy Hull
 
Or make a form.. and put some code in 'OnTimer' event like

Private Sub On_Timer

Select Case Time

Case is = #6:15:00 AM#
Call yoursub
end select

Then it will call that sub at 6.15///

Although if the timer interval is 1ms.. it will keep calling it for that
whole minute.. maybe.. not sure

--
Regards,

James Hitchcock
Spider Software
(e-mail address removed)
+44 (0)7858 383 794
 
Back
Top