Does anyone know where I can get the datepicker activex control - FREE OF
CHARGE - it is not listed in my references or Additional Controls......

It is in the common controls in file: MSComct2.OCX (see download links at
the bottom of my note). All links that cover more than one line should be
pasted into Notepad and made into one line, then pasted into your browse
navigation bar.


Located in:
oldName:
Comctl232.ocx
NewName:
MSComct2.OCX

Animation control
Datetimepicker control
Monthview control
Updown control
http://msdn.microsoft.com/library/de...cont rols.htm


http://msdn.microsoft.com/library/of...plications.htm
Using Data-Aware Controls in Office Applications

extract:
Data-Aware Controls in Office 2000 Developer

. . .

The Microsoft Office 2000 Developer includes several data-aware controls,
which can be used to display data either when inserted into Office
application documents or when used on a VBA UserForm.

. . .
Microsoft DateTimePicker Control Similar to the MonthView control, except
the calendar drops down from a textbox for date entry saving space in a user
interface layout.



------------------<VB 6 related documentation--------
http://msdn.microsoft.com/library/de...kercontrol.htm

http://msdn.microsoft.com/library/de...kercontrol.htm

http://msdn.microsoft.com/library/de...ePicker_m.html

http://msdn.microsoft.com/library/de...excontrols.htm

================

Some download locations:

http://www.magente.com/m/CServ/cp.asp

http://www.windows-hq.com/Download/winhvanceFAQs.cfm
see bottom of page

http://www.santanacreations.com/needed_files.html

http://members.tripod.com/~minzy/softwares.html
Look down toward the bottom - name of files are links to download

http://www.10tec.com/download.shtml
See the bottom of the page.

--
Regards,
Tom Ogilvy



"ibeetb" wrote in message
...
Does anyone know where I can get the datepicker activex control - FREE OF
CHARGE - it is not listed in my references or Additional Controls......

Hi

There are several freeware replacements for the Datepicker control that
appear to work well with VBA.
One is available here http://www.mvps.org/ccrp/download/ccrpdownloads.htm

I went to Microsofts site as pointed to by Tom Ogilvy, but could not tell
for sure if the Ms common control
is just a part of VB6 or if it is available to use and distribute freely
with VBA as well.

Maybe Tom Knows and can inform us.


HTH

Ken



"ibeetb" wrote in message
...
Does anyone know where I can get the datepicker activex control - FREE OF
CHARGE - it is not listed in my references or Additional Controls......





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.525 / Virus Database: 322 - Release Date: 09/10/2003