To define a date to run a macro (?)

[an]

Hello!

Is it possible to define a date to run a macro, please?

Thanks in advance.
an

 

[Steve Schapel]

An,

You can use Windows Task Manager, or other scheduling utility, to run
the macro at a specified date/time. Is that what you mean? If not, can
you explain in more detail what you want to do? Thanks.

 

[an]

SS,

Thank you for your reply.

I would like to run a Macro to Quit Acess or Delete a Table, for example,
after defined date.

If determined condition she had been fulfilled, it redispatched another
copy, if not, that one left to function

Thanks.
an

 

[Steve Schapel]

An,

It is very easy to make a macro to do what you say. In your example you
would use a Quit action and/or a DeleteObject action, and you can put a
Condition (select this from the View menu if you can't see a Conditions
column in the macro design window), which something like this...
Date()>#2/02/2006#

Possibly the more tricky question is *when* you want this to happen.
When you open the database? When you open or close a particular form?
When you click a button? At 2:00am? This will determine what event you
assign the macro to.

 

[an]

SS,

Thanks for your solution.
an

An,

It is very easy to make a macro to do what you say. In your example you
would use a Quit action and/or a DeleteObject action, and you can put a
Condition (select this from the View menu if you can't see a Conditions
column in the macro design window), which something like this...
Date()>#2/02/2006#

Possibly the more tricky question is *when* you want this to happen.
When you open the database? When you open or close a particular form?
When you click a button? At 2:00am? This will determine what event you
assign the macro to.