Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Schedule a function

Status
Not open for further replies.

Klo

Technical User
Aug 28, 2002
86
US
Is it possible to schedule a function to run at a certain time each night?
 
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
 
Thanks. I'll give it a try tonight.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top