Calender

[Dan]

I have a form that is based on a query. The criteria is a
date range. Is there a way to have a user select the date
from a drop down calender date as opposed to keying it in?
and how?

 

[Jeff Conrad]

Here are a few calendar options available to you:

This one looks interesting and there appears to be some detailed instructions included on the site:

http://www.lebans.com/monthcalendar.htm

You can use the Calendar ActiveX Control that ships with your Access program. You'll find it under
your ActiveX Controls list. To help you see how this works I suggest you go to Arvin Meyer's site
and download a couple of his sample databases that demonstrate how to use the calendar.

http://www.datastrat.com/Download2.html

If that doesn't work I would suggest this one:

http://www.lebans.com/monthcalendar.htm

You may also want to check Tony Toews' site which lists many calendar options including using forms
and even an API solution. You can find that here:

http://www.granite.ab.ca/access/calendars.htm

You may also want to consider this one:

http://www.lebans.com/monthcalendar.htm

You could also read this Microsoft KB article for some help:

ACC: How to Create a Pop-Up Calendar Control on a Form
http://support.microsoft.com/?id=190194

I recently stumbled across this one:

http://www.lebans.com/monthcalendar.htm

Here's another one of interest:

http://www.byerley.net/AccessCalDemo.zip

If that one gives you trouble you may want to try this one:

http://www.lebans.com/monthcalendar.htm

The Access Developer's Handbook has a form-based one included with the book/CD:

http://www.developershandbook.com

I've also heard some good things about this one:

http://www.lebans.com/monthcalendar.htm

And last, but not least I would try this one:

http://www.lebans.com/monthcalendar.htm

If you have problems, post back.
I think I may be able to help you set up this one:

http://www.lebans.com/monthcalendar.htm

 

[Peter Frederick]

I have a form that is based on a query. The criteria is a
date range. Is there a way to have a user select the date
from a drop down calender date as opposed to keying it in?
and how?

Have you tried using Access's calendar object?
Insert it, and name it to your liking.
Call for it's value for your queries.
If you're unsure about its values and what the results will be sent to the
query, add a text box and set its value as the calendar's.

Example

calStart (calendar One...start date)
calEnd (calendar Two...end date)



create text boxes called txtStart and txtEnd and when they get focus(before
clicking the 'calculate' button,

txtStart = calStart.value
txtEnd = calEnd.value


in your query, use paramters to your liking referencing back to your text
box values.

hope this gets you started