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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Time-triggered execution of a module

Status
Not open for further replies.

tbruehlm

Programmer
Jun 8, 2006
1
CH
Hello all,
I'm a newbie in MS Access and VBA.
I have a module in MS Access, creating and exporting a file from data.

How is it possible to execute this script on a time-triggered basis, like: every night?

Thanks, Tobias
 
A. Cost-Free way
1.Create a macro that runs your code
2.Create a shortcut that opens your database with startup command-line option to run the macro from step 1
3.Create a schedule task to run the shortcut
B. Not Cost-free way
HandyAccessLauncer. The latest version of HAL can be found at
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top