Drop Down Calendar

[Chris Ball]

Hi,

I want to add a drop down Calendar to a date field on a
form so the user can click on a drop down field and then
choose the date by clicking (as in Outlook etc)

Anyone know how??

 

[Joan Wild]

Have a look at
http://www.lebans.com/monthcalendar.htm

 

[Tim Ferguson]

I want to add a drop down Calendar to a date field on a
form so the user can click on a drop down field and then
choose the date by clicking (as in Outlook etc)

If you are using Access 97 to 200, go to <http://www.mvps.org/ccrp/> and
look for the datepicker control.

From 2002 upwards, I believe it is part of the application anyway.

HTH


Tim F

 

[Philip]

In Access 2000/XP you might try using the "Microsoft Date
and Time Picker Control" (MSComCtl2.DTPicker.2 class).

You will find it at the "Insert / ActiveX Controls" menu
option which is available in the Form-Design menubar. If
it is not there, then you probably dont have
the "mscomct2.ocx" ActiveX installed on your PC.

You might find information on getting the control from
microsoft
on "http://msdn.microsoft.com/vbasic/downloads/tools/axupgr
ade.aspx".

Philip

 

[roy]

if you need the control (it is not in the standard installation of 2003) look at Microsoft Knowledge Base article 297381