Calendar Control

[Jasper Recto]

I have a query that prompts the user for the start date and end date
criteria.

I created a form with a button that launches that query.

I would like to insert a 2 calendars on that form that represent the start
and stop date. The user would just click on the dates from each calendar
and then click on the button to lauch the query.

I would like to pass the dates to the query.

How would I do this?

Thanks,
Jasper

 

[pietlinden]

I have a query that prompts the user for the start date and end date
criteria.

I created a form with a button that launches that query.

I would like to insert a 2 calendars on that form that represent the start
and stop date.  The user would just click on the dates from each calendar
and then click on the button to lauch the query.

I would like to pass the dates to the query.

How would I do this?

Thanks,
Jasper

You could use one of Stephen Lebans' calendars...
Then you would do something like

SELECT ...
FROM MyTable
WHERE SomeDate BETWEEN Forms![Form1]![txtStartDate] AND Forms![Form1]!
[txtEndDate]

 

[pddxxx]

We've created an easy way to implement Stephen Lebans' MonthCalendar.
You can copy and paste the controls and modules from our free example
application into yours and implement date selection on your form with
no coding. Here's the link: http://www.peterssoftware.com/prx.htm

Hope this helps,

Peter De Baets
http://www.peterssoftware.com

 

[Arvin Meyer [MVP]]

I have an Access calendar form that works (with conversion) on every version
of Access from 2.0 through 2007:

http://www.datastrat.com/Download/Calendar2K.zip

You can also use the activex control, but you'll need one for each and every
text box you wish to display:

http://www.datastrat.com/Download/XCalendar2K.zip