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
|
|||
|
|||
filling dates using a calendar
I have a report that has a Record Start Date and a Record End Date. I would
like to have a calendar pop up, pick the dates using the calendar, and then have the Record Start Date Field and the Record End Date Field updated respectively. So far I have not had any success with this. I can change the calendar's date by entering a date in the appropriate date field, but I cannot achieve the oppisite effect. Would anyone be able to point me in the correct direction. One other thing, I am farely new to access, but I do catch on quickly. Thanks, Jimmy P. |
#2
|
|||
|
|||
filling dates using a calendar
The solution I used for this item was by Allen Browne
http://allenbrowne.com/ser-51.html With his solution you download the caledar form and buttons. You simply copy the calendar form to your forms area and copy the sample button to your form where you place it next to the control where you want to enter the date. You change the OnClick event of the button to reflect your controls name. =CalendarFor([Date_of_Enquiry],"Set the Enquiry Date") (My controls name is [Date_of_Enquiry] as you can see above, the text in quotes is a comment for notes) Then when you select the date on the Calendar, it pops the date selected straight into the control on your form. Copy the button as many time as you have date fields and just change the on click event to the new field name. I hth MikeB "Jimmy P." wrote: I have a report that has a Record Start Date and a Record End Date. I would like to have a calendar pop up, pick the dates using the calendar, and then have the Record Start Date Field and the Record End Date Field updated respectively. So far I have not had any success with this. I can change the calendar's date by entering a date in the appropriate date field, but I cannot achieve the oppisite effect. Would anyone be able to point me in the correct direction. One other thing, I am farely new to access, but I do catch on quickly. Thanks, Jimmy P. |
#3
|
|||
|
|||
filling dates using a calendar
Sorry I didn't notice you said REPORT, dont know if this will work in reports.
"Jimmy P." wrote: I have a report that has a Record Start Date and a Record End Date. I would like to have a calendar pop up, pick the dates using the calendar, and then have the Record Start Date Field and the Record End Date Field updated respectively. So far I have not had any success with this. I can change the calendar's date by entering a date in the appropriate date field, but I cannot achieve the oppisite effect. Would anyone be able to point me in the correct direction. One other thing, I am farely new to access, but I do catch on quickly. Thanks, Jimmy P. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Any suggestions on implementing internal calendar for a university | Shiva | General Discussion | 1 | September 23rd, 2005 03:21 AM |
Can you export dates from excel as due dates in Outlook calendar? | Brent | General Discussions | 1 | September 21st, 2005 10:48 PM |
looking for a calendar template that I can import multiple dates | bkrizman | General Discussion | 0 | June 1st, 2005 11:16 PM |
Calendar Question | Josh | General Discussion | 7 | March 28th, 2005 11:19 PM |
Yearly Calendar report with highlighted dates | Tami Lamz | General Discussion | 1 | January 19th, 2005 06:44 AM |