MS Access calendar 9.0 to pick dates on a form

[Matthew]

I currently have a form in MS Access that has certain combo boxes
which specify criteria in order to run a query based on that criteria.
I want to add to this, a calendar from which a user will be able to
click on a date, where the chosen date will then be used as the
criteria for the control source of the calendar. What do I need to do
to make the calendar active?? I can physically get it on my form, and
specify the criteria in my query, but the calendar is not
functional(i.e. it doesn't do anything when I try clicking on a date).
Any ideas??

Thanks...

Matt

[Tony Toews]

ma************@eaton.com (Matthew) wrote:

I currently have a form in MS Access that has certain combo boxes
which specify criteria in order to run a query based on that criteria.
I want to add to this, a calendar from which a user will be able to
click on a date, where the chosen date will then be used as the
criteria for the control source of the calendar. What do I need to do
to make the calendar active??

See the Calendar Tips page at my website
http://www.granite.ab.ca/access/calendars.htm

There could, likely will, be lots of version problems when you go to distribute the
MSCal.OCX..

One alternative is MonthCalendar is a completely API generated Month Calendar derived
directly from the Common Control DLL. There are links to several downloadable
calendar forms at my website. As these are forms you can also do anything with them
you want.

You can also use the calendar form which comes in the Access <insert your version
here> Developers Handbook by Litwin/Getz/Gilbert, publisher Sybex
www.developershandbook.com. These books are well worth spending money. Every time I
open one I save the price of the book.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Tony D'Ambra]

Use this code to trap the user click:

Private Sub Calendar1_AfterUpdate()
On Error GoTo ErrorTrap
Dim dteSelectedDate As Date
dteSelectedDate = Me.Calendar1.Value
Exit Sub
ErrorTrap:

MsgBox "Error " & Err & ". " & Err.Description & ".", vbCritical
Resume Next

End Sub

--

Tony D'Ambra
Web Site: aadconsulting.com
Web Blog: accessextra.net

"Matthew" <ma************@eaton.com> wrote in message
news:7f**************************@posting.google.c om...

I currently have a form in MS Access that has certain combo boxes
which specify criteria in order to run a query based on that criteria.
I want to add to this, a calendar from which a user will be able to
click on a date, where the chosen date will then be used as the
criteria for the control source of the calendar. What do I need to do
to make the calendar active?? I can physically get it on my form, and
specify the criteria in my query, but the calendar is not
functional(i.e. it doesn't do anything when I try clicking on a date).
Any ideas??

Thanks...

Matt

[Tony D'Ambra]

Use this code to trap the user click:

Private Sub Calendar1_AfterUpdate()
On Error GoTo ErrorTrap
Dim dteSelectedDate As Date
dteSelectedDate = Me.Calendar1.Value
Exit Sub
ErrorTrap:

MsgBox "Error " & Err & ". " & Err.Description & ".", vbCritical
Resume Next

End Sub

--

Tony D'Ambra
Web Site: aadconsulting.com
Web Blog: accessextra.net

"Matthew" <ma************@eaton.com> wrote in message
news:7f**************************@posting.google.c om...

I currently have a form in MS Access that has certain combo boxes
which specify criteria in order to run a query based on that criteria.
I want to add to this, a calendar from which a user will be able to
click on a date, where the chosen date will then be used as the
criteria for the control source of the calendar. What do I need to do
to make the calendar active?? I can physically get it on my form, and
specify the criteria in my query, but the calendar is not
functional(i.e. it doesn't do anything when I try clicking on a date).
Any ideas??

Thanks...

Matt