Scheduling Macro's 1

[NOPOPNOSTYLE]

Hi Everyone

Is is possible to write a Module that will schedule a Macro to run at a specific time every day based on a server's bios clock?

Many Thanks

Lord Exell

 

[PaulBricker]

Take a look at this thread. It should get you started.

Paul

thread702-382899

 

[NOPOPNOSTYLE]

Paul

That works fine, however one small hitch. The Macro I'm running uses the Copy Object Function to Copy a table and rename it as a existing table thus overwriting it, when run manually it prompts a "yes/no" pop up box asking whether you wish to overwrite the existing table. Is thier a way of getting the macro to say "yes" to this question automatically every time?

Lord Exell

 

[mp9]

An alternative to Windows Task Scheduler which uses less resources and encrypts your password info for scheduling tasks in secured databases is HAL, a freeware app you can download from

http://www.winsite.com

(search for "Handy Access Launcher" to find it).

In answer to your follow-up question, why not get the macro to delete the existing object first, then copy over it - this won't cause a "confirm" prompt.

If the idea of deleting the old object before you've copied the new object fills you with paranoia about lost objects, you might want to try renaming the old object rather than deleting it. The sequence of events would then be:

1. Rename old object
2. Copy new object to original name of old object
3. Delete renamed object

This is a bit long-winded but will work if you want to do everything in a macro.

http://www22.brinkster.com/accessory/

 

[MasterLu]

you can also start the macro by adding the action "SetWarnings" to "No" (this will turn all yes/no prompts off) and then end your macro with the action "SetWarnings" to "Yes" to turn them back on.