May 21, 2004 #1 Klo Technical User Aug 28, 2002 86 US Is it possible to schedule a function to run at a certain time each night?
May 21, 2004 #2 drctx IS-IT--Management May 20, 2003 226 US yes. if the computer stays on all night and it has access loaded. create a macro to call the function. then create a scheduled task to run that will call the macro like this, add the name of the macro after the /x "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\folder\databases.mdb" /xMACRONAME Upvote 0 Downvote
yes. if the computer stays on all night and it has access loaded. create a macro to call the function. then create a scheduled task to run that will call the macro like this, add the name of the macro after the /x "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\folder\databases.mdb" /xMACRONAME
May 21, 2004 Thread starter #3 Klo Technical User Aug 28, 2002 86 US Thanks. I'll give it a try tonight. Upvote 0 Downvote