use calender to find dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

datahunter - 20 Apr 2008 22:34 GMT

i am using the calender to fill in a date field but have found a need to have
a search done to see if that date is used all ready. How do i add the
search part to my calender.

Reply to this Message

Jeff Boyce - 21 Apr 2008 13:46 GMT

Without a better idea of your underlying data structure (it all starts with
the data), it will be tough to offer specific suggestions.

I would guess that you would have to store, somewhere, the fact that a date
was "already used" (whatever that means to you). Could you try looking for
that date in that place in the BeforeUpdate event of the control in which
you are trying to store the date?

Signature

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

> i am using the calender to fill in a date field but have found a need to have
> a search done to see if that date is used all ready. How do i add the
> search part to my calender.

Reply to this Message