Hi Mike,
Take a look at
ACC2000: How to Start Access by Using the Windows NT Schedule Service
http://support.microsoft.com/default.aspx?scid=kb;en-us;230575
and
http://www.mvps.org/access/modules/mdl0042.htm
and
Also do a Google search on "Task", "Scheduler"
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
--------------------
| Content-Class: urn:content-classes:message
| From: "Mike" <
[email protected]>
| Sender: "Mike" <
[email protected]>
| Subject: Automatically run code at given time.
| Date: Wed, 18 Feb 2004 04:56:37 -0800
| Lines: 11
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcP2HqU6S52vAzy0Td2h3CgsLdri8A==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.modulesdaovba
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.modulesdaovba:124472
| NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
| X-Tomcat-NG: microsoft.public.access.modulesdaovba
|
| 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
|
