Calendar Control

J

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
 
P

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
Click to expand...

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]
 
Top