preventing a job from running more than once a year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro that appends records to a file, but I don't want this job to
be run more than once a year. I hold the the date the job is run and I need
to compare the date entered by user to this date. I'm not any good with
visual basic so if you could do it with querys and macros it would be
helpful. Thanks.
 
Tell us more details about how you "hold" the date information and what
occurs that would trigger the running of the job that may need to be
"stopped".
 
Hi Ken,
I managed to accomplish what I wanted by using Dlookup as a condition in a
macro. Thanks for you assistance.
 
Back
Top