A
Alex Martinez
Hello,
I am using Access 2002 and I wanted a calendar control similar to a date and
time picker without the hassle of null date. So I decide to use a toggle
button next to my date text box I also used a calendar control. In my
toggle button (toggleAssignedDate) I use on Click event this code:
Private Sub ToggleAssignedDate_Click()
With Me
!Calendar8.Visible = Not (ToggleAssignedDate) = 0
End With
End Sub
I set the control source in the calendar to assignedOn (date text box) and
format it to not be visible. What the user will do is press the toggle
button and the calendar control will pop up and the user select the day and
press the toggle button to make the calendar control not be visible. The
assignedOn (date text box) get populated. Now this works fine, but I would
like the user to press one less button. I also would like the calendar
control to show today's date so I can select the correct date usually a day
or two or even the week before from today's date. The problem I get is I get
the last date from the previous entry. The second thing I would like is
when I press the particular date in the calendar control I want the
assignedOn (date text box) to be populated and the calendar control to not
be visible again until the toggleAssignedDate button (toggle button) is
press again. Any tips will be appreciated. Thank you in advance.
I am using Access 2002 and I wanted a calendar control similar to a date and
time picker without the hassle of null date. So I decide to use a toggle
button next to my date text box I also used a calendar control. In my
toggle button (toggleAssignedDate) I use on Click event this code:
Private Sub ToggleAssignedDate_Click()
With Me
!Calendar8.Visible = Not (ToggleAssignedDate) = 0
End With
End Sub
I set the control source in the calendar to assignedOn (date text box) and
format it to not be visible. What the user will do is press the toggle
button and the calendar control will pop up and the user select the day and
press the toggle button to make the calendar control not be visible. The
assignedOn (date text box) get populated. Now this works fine, but I would
like the user to press one less button. I also would like the calendar
control to show today's date so I can select the correct date usually a day
or two or even the week before from today's date. The problem I get is I get
the last date from the previous entry. The second thing I would like is
when I press the particular date in the calendar control I want the
assignedOn (date text box) to be populated and the calendar control to not
be visible again until the toggleAssignedDate button (toggle button) is
press again. Any tips will be appreciated. Thank you in advance.