Calander

[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.

 

[Ron Weiner]

If I were you. I would loose the Active X control in a heartbeat.
Ultimately they only cause problems down the road with missing files,
references, and versioning problems (can you spell DLL hell). I recommend
you go here:
http://allenbrowne.com/ser-51.html
and download Allen Brownes Pop Up Calendar demo database.

In fact about a month ago I did just that for a project. It worked well, was
simple to implement, and because you have the source
code (it is a 100% Access only solution) you can easily make changes to the
calendar. I was able to easily add a "goto today" feature that the customer
requested in less than 5 minutes programming time.

Ron W
www.WorksRite.com