Help with Pop-up Calendar on form

[Nathan Lars]

I am following the Access tips from the following wedsite link and trying to
figure this out without bothering anyone but I am stumped.

http://www.fontstuff.com/access/acctut09.htm

I have entered the below text into the Date field combo box's Mouse Down
event procedure and substitued the cboStartDate and ocxCalendar names with
the names i have called them in an existing database, but I can't get it to
work.

Private Sub Date_MouseDown(Button As Integer, Shift As Integer, X As Single,
Y As Single)
ocxCalendar.Visible = True
ocxCalendar.SetFocus
If Not IsNull(cboStartDate) Then
ocxCalendar.Value = cboStartDate.Value
Else
ocxCalendar.Value = Date
End If

What am I doing wrong?

 

[Daniel Pineault]

In general ActiveX controls should be avoided when possible. As such, I
would urge you to use either

http://allenbrowne.com/ser-51.html
or
http://www.lebans.com/monthcalendar.htm

I have used both. They are easy to setup and never fail!

 

[Nathan Lars]

I will check those out. Thank you for your help.

 

[Nathan Lars]

You're right, that was easy. I think looks cleaner than the other Calendar.

Is there a way to control where the calendar pops-up after the button is
selected? Right now it seems to open in the center of the form, but I would
like it to open immediately to the right of the button for greater
effeciency.