If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calendar Control
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 |
#2
|
|||
|
|||
Calendar Control
On Jul 21, 1:23*pm, "Jasper Recto" wrote:
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] |
#3
|
|||
|
|||
Calendar Control
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 |
#4
|
|||
|
|||
Calendar Control
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 -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Jasper Recto" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|