calendar

[fanfan2]

Is there a way to put a little button on a form that on click opens a calendar that user can choose a date, then base on the date opens a query? thanks in advance.

 

[ajetrumpet]

check out my calendar forms in the faq section here. it is called CUSTOM CALENDAR FORM

 

[fanfan2]

I searched "CUSTOM CALENDAR FORM" under FAQ but couldn't find it.

 

[ajetrumpet]

http://www.access-programmers.co.uk/forums/showthread.php?t=181469

 

[Alansidman]

This is my favorite to use. Simple and easy to install in any Access dB

http://allenbrowne.com/ser-51.html

Alan

 

[fanfan2]

Where can I find the access2007 build-in calendar? Thanks.

 

[fanfan2]

I found the calendar contol. Now I want to be able to click on the calendar then opens a query with the date as the criteria. On the calendar control property, I set the event "on update" to the query name, then in the query criteria I put "[form]![frmName]![CalendarControl].[value]. But it didn't work. What did I do wrong? Thanks.