filling dates using a calendar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top