Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-30-2003, 12:54 PM   #1
Bob Thornton
Junior Member
 
Join Date: Jan 2002
Location: Toledo, Ohio USA
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Bob Thornton
schedule a macro to run

I have a macro that deletes a table, then imports a text file to a table of the same name as the one that was deleted. My objective is to schedule a macro to run at regular intervals automatically. Ideally, I'd like to have this macro run during the night or on weekends. The Access DB is located on a network drive so I won't have to be logged in to have this run?? How do I set this macro up? All help is greatly appreciated !!

Bob Thornton is offline   Reply With Quote
Old 05-30-2003, 02:26 PM   #2
Mile-O
Back once again...
 
Mile-O's Avatar
 
Join Date: Dec 2002
Location: Glasgow, UK
Posts: 11,312
Thanks: 4
Thanked 118 Times in 108 Posts
Mile-O will become famous soon enough
As long as you have the database open AT ALL TIMES then you can have a form open on that database and use it's Timer() event.

Last edited by Mile-O; 06-02-2003 at 05:47 AM.
Mile-O is offline   Reply With Quote
Old 06-02-2003, 05:42 AM   #3
Bob Thornton
Junior Member
 
Join Date: Jan 2002
Location: Toledo, Ohio USA
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Bob Thornton
scheduled macro

What happens if I don't have the database open? Let's say I want this to run at 3 in the morning or at a time when I'm not at work??

Thanks!

Bob Thornton is offline   Reply With Quote
Old 06-02-2003, 05:47 AM   #4
Mile-O
Back once again...
 
Mile-O's Avatar
 
Join Date: Dec 2002
Location: Glasgow, UK
Posts: 11,312
Thanks: 4
Thanked 118 Times in 108 Posts
Mile-O will become famous soon enough
Then, it won't run.
Mile-O is offline   Reply With Quote
Old 06-04-2003, 11:42 PM   #5
IMO
Now Known as ___
 
IMO's Avatar
 
Join Date: Sep 2002
Location: On a small Asteroid Orbiting Planet Zog, I think!!
Posts: 723
Thanks: 0
Thanked 1 Time in 1 Post
IMO is on a distinguished road
You could create a new db with a 'Make Table Query' (which makes the table in your current db), and form which runs your macro on opening. Set the form to open on startup and set the form timer to "Quit" the database after 1min (or however long it takes to run your macro). Then place the new db in the Windows Scheduler.

IMO

__________________
Now known as ___

Last edited by IMO; 06-04-2003 at 11:56 PM.
IMO is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 04:04 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World