To define a date to run a macro (?)

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
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.
 
SS,

Thanks for your solution.
an


Steve Schapel said:
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.
Click to expand...
 
Back
Top