how to schedule a macro

[krishreddy]

hi,

cud anyone let me know how to schedule a macro?

waiting for reply.

krishreddy

 

[TheAceMan1]

How are ya krishreddy . . .
[ol][li]Set an [blue]AutoExec[/blue] macro to run your code. Be aware . . . you can use any macro to run code residing in VBA![/li]
[li]Use Microsofts [blue]Task Scheduler[/blue] to open the db ([blue]AutoExec[/blue] automatically runs when you open a db).[/li]
[li]Allowing enough time for the macro to run, you can subsequently close the db with [blue]Task Scheduler[/blue].[/li][/ol]
[blue]Your Thoughts?[/blue]

See Ya! . . . . . .

 

[TheAceMan1]

krishreddy . . .

In my prior post 3 should read

[blue]3. In code when the routine is complete, close the db.[/blue]

See Ya! . . . . . .

 

[DrSimon]

Hi Guys
AceMan1 is right as always, but don't forget that you can also use /x "macroname" as an argument when opening Acess. See Help for command-line options for full syntax. And you can still use the Task Scheduler.