Linking The Calendar to Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard C - 06 Sep 2004 13:57 GMT

I was looking at the post earlier about using the activex
calendar and then linking it to a query. I would like to
do the same thing. I am tryning to create a working
calendar to allow the input of events, and then the user
can check the calendar and see what is going on that day!

I have the event input working fine, but I want to be able
to display the current months days and when the users
clicks on the day the query is then called on, and the
days events and details are displayed to the user! Can
anyone tell me how to do this?

Rich

Reply to this Message

Alex Dybenko - 07 Sep 2004 07:49 GMT

Rich,
you can use calendar's Click Event to modify query SQL or apply filter.
for example, if you have a subform to show events:

me.MySubform.form.recordsource = "Select * from MyEventsTable where
EventDate = #" & format(me.Calendar1.value,"mm\/dd\/yyyy") & "#"

HTH

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

>I was looking at the post earlier about using the activex
> calendar and then linking it to a query. I would like to
[quoted text clipped - 9 lines]
>
> Rich

Reply to this Message