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
|
|||
|
|||
Problems with Calendar Control
I have a query that retrieves a bunch of data from a table, including a date
field. I have a form that displays the query results. On the form I have two calendar controls. The user selects the start date from one calendar and then the end date from the other calendar. In the query I have set the criteria in the date field to select only records that are between the two calendar dates (Between Forms![My Sales].calStart.Value And Forms![My Sales].calEnd.Value). If I hard code two dates for the date field criteria and then open the form, I can click on the calendar controls and select a date (of course that doesn't do anything). When I change the criteria to select the dates from the calendar controls, I have problems. When I open the form the calendar controls are locked. I can't select a date on the calendar - clicking on the calendar does nothing. I don't know why this is happening. How do I fix this problem? I'm using Access 2000 with Calendar Control 10.0 Thanks in advance. Evan |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
calendar control | Loi | General Discussion | 0 | August 6th, 2004 06:20 PM |
Access Calendar | lost | General Discussion | 2 | July 7th, 2004 04:58 AM |
AfterUpdate event of Calendar Control in Access 2000 not firing as expected? | Gary | Using Forms | 3 | July 2nd, 2004 07:53 PM |
Calendar Control | Ant | General Discussion | 3 | June 17th, 2004 06:16 PM |
Calendar Control Active X 10 problem | DubboPete | Using Forms | 6 | May 28th, 2004 11:05 AM |