Conditional On Timer Event

  • Thread starter Thread starter Timothy
  • Start date Start date
T

Timothy

is there a way to set an event using the on timer function
that is set for a date once a month that will run a macro,
But the timer would reset if someone manually ran the
macro? Trying to automize a report macro that prints
things out once a month, Unless a user has already done it
then the timer resets to the next month.

Thanks \

Timothy
 
For a "persistent value" as you desire, you will need to store it in a
table, or create a property of the database in which to store it. I can't
say if you could do this with macros, but you could do it with code.
Frankly, if it is a monthly thing, I'd suggest storing a date in a table and
checking it in code that runs at startup rather than having a timer going
whenever the application runs.

I have some random thoughts on using a table or properties to store
application data at http://accdevel.tripod.com... look under Articles.

If you need to follow up or clarify, please do so here in the newsgroup, not
by e-mail. Thanks.

Larry Linson
Microsoft Access MVP
 
I would love extra help on this...if a table is what needs
to be done..thats fine. I looked at that link but didnt
see what you were talking about. Any help would be
appreciated.

Timothy
 
Back
Top