I am building an Access 2007 database where a user would enter the
start and end date of a holiday period in two date fields. I want
Access to automatically clear both date fields once the period has
expired. Can anyone tell me if this is possible and if it is what VBA
code I would need to use.

Thanks,

Steve

stevmich,
You can run an Update query against your table... to Null out
the StartDate and EndDate where today's date (Date()) is
greater than EndDate.

A more important question is... what triggers this Update?

If you open the database application every day, that would be a
good time to check the table for records that need updating.

I have a database that never (or rarely) shuts down, so I have
a button on the Main Menu that blinks a red caption
(on the supervisor's PC only)... indicating that some function needs
to be run... every X amount of days.
This could be totally automated, but the user would rather be
notified, and start the routine manually.

Something to consider...
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."








"stevmich" <(E-Mail Removed)> wrote in message
news:b733f91b-2537-413e-b699-(E-Mail Removed)...
>I am building an Access 2007 database where a user would enter the
> start and end date of a holiday period in two date fields. I want
> Access to automatically clear both date fields once the period has
> expired. Can anyone tell me if this is possible and if it is what VBA
> code I would need to use.
>
> Thanks,
>
> Steve

On 22 Jan, 14:14, "Al Campagna" <newsgro...@comcast.net> wrote:
> stevmich,
> * * You can run an Update query against your table... to Null out
> the StartDate and EndDate where today'sdate(Date()) is
> greater than EndDate.
>
> * * A more important question is... what triggers this Update?
>
> * * If you open the database application every day, that would be a
> good time to check the table for records that need updating.
>
> * * I have a database that never (or rarely) shuts down, so I have
> a button on the Main Menu that blinks a red caption
> (on the supervisor's PC only)... indicating that some function needs
> to be run... every X amount of days.
> * * This could be totally automated, but the user would rather be
> notified, and start the routine manually.
>
> * * Something to consider...
> --
> * * hth
> * * Al Campagna
> * * Microsoft Access MVP 2006-2009
> * *http://home.comcast.net/~cccsolutions/index.html
>
> * * "Find a job that you love... and you'll never work a day in your life."
>
> "stevmich" <stevm...@tiscali.co.uk> wrote in message
>
> news:b733f91b-2537-413e-b699-(E-Mail Removed)...
>
> >I am building an Access 2007 database where a user would enter the
> > start and enddateof a holiday period in twodatefields. I want
> > Access to automaticallyclearbothdatefields once the period has
> >expired. Can anyone tell me if this is possible and if it is what VBA
> > code I would need to use.
>
> > Thanks,
>
> > Steve

Thanks Al I'll give it a try. Regards, Steve