preventing a job from running more than once a year

[John (Big Guy)]

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.

 

[Ken Snell \(MVP\)]

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".

 

[John (Big Guy)]

Hi Ken,
I managed to accomplish what I wanted by using Dlookup as a condition in a
macro. Thanks for you assistance.