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

automate a function

Status
Not open for further replies.

axism

MIS
May 17, 2005
58
I have a function that needs to run every friday, I would like to know how I can automate it to run every friday?
 
If you use advanced search with Automate as a key word, you will find lots of ideas.
 
If WeekDay(Me.txtDate) = 6 Then....

...I think Friday is 6? ...or 5?
 
How are ya axism . . .

Not sure if this is what you want but you could use windows [blue]Task Scheduler[/blue] to open the db. The db runs the [blue]AutoExec[/blue] macro which calls a [blue]routine that runs your function[/blue] and subsequently [blue]closes the db . . .[/blue]

[purple]Your Thoughts? . . .[/purple]

Calvin.gif
See Ya! . . . . . .
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top