Automatically run code at given time.
From: Matt Kisasonak (anonymous_at_discussions.microsoft.com)
Date: 02/18/04
- Next message: tim johnson: "email from Access"
- Previous message: R: "export (Apend - not new)"
- Next in thread: Chris: "Automatically run code at given time."
- Reply: Chris: "Automatically run code at given time."
- Maybe reply: prabha: "RE: Automatically run code at given time."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 18 Feb 2004 06:33:06 -0800
If you have a form open around 5pm, you can use the On
Timer event of the form. Set the Timer Interval to a
minute (60,000 milliseconds) and check if the Time() is
5:00 and if so, run the code.
>-----Original Message-----
>I have a function that outputs a query to excel. I run
>this code every day. Currently I have to hit a command
>button to run the code. I am looking for a way to have
>the database do this automatically at 5PM. The output
>code is: DoCmd.OutputTo
>acOutputQuery, "qryOpenPBConPriorityCountCrosstab",
>acFormatXLS, "P:\Phil Hull\PBContractorOpenItemCount", -1
>The database is on a server and I would like it to
>automatically run this code at 5PM. I would appreciate
>your help with the automation code.
>Thanks, Mike
>.
>
- Next message: tim johnson: "email from Access"
- Previous message: R: "export (Apend - not new)"
- Next in thread: Chris: "Automatically run code at given time."
- Reply: Chris: "Automatically run code at given time."
- Maybe reply: prabha: "RE: Automatically run code at given time."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
