> Hi there

> I have a problem with the DTPicker (Date Time Picker) control on a 
couple 
o> f forms which I am developing and would appreciate any help.

> OK then here goes, I have 2 forms formA contains several chunks of data 
i> ncluding a couple of dates set via a couple of dtpicker controls.

> I then load up formB this then fires up a couple of sql queries to 
p> opulate the controls on the form, the data is the retrieved and I 
attempt 
t> o populate the 2 DTPicker controls on FormB with a couple of dates from 
t> he recordset like so :- 

> dtpRefDate.Value = rs.Fields("ReferredDate").Value, this in turn returns 
a 
r> untime error - 2763 stating that an error occurred in the windows date 
t> ime picker control

> Has anyone come across this ???

> Secondly where have all the DTPicker controls Methods/Properties gone, 
in 
V> B6 I can access things such as dtpicker.date, Month, Time etc etc 

> Thanks for any help

> 
This is absolutely no help at all but I have the same problem! Awful isn't 
it? What version is your MSCOMCT2.OCX or whatever the DTPicker control is 
help in? I have the same problem at work under NT4 and here under XP, 
although the disks I installed the VB from are the same in both cases.

John Stout

Hi John

why don't you try this

dtpRefDate.Value = format(rs.Fields("ReferredDate").Value,"mm/dd/yyyy")

maybe work


----- Original Message -----
From: "John Stout" <jstout@c...>
To: "Access" <access@p...>
Sent: Thursday, February 13, 2003 10:43 PM
Subject: [access] Re: Date time picker control


> > Hi there
>
> > I have a problem with the DTPicker (Date Time Picker) control on a
> couple
> o> f forms which I am developing and would appreciate any help.
>
> > OK then here goes, I have 2 forms formA contains several chunks of data
> i> ncluding a couple of dates set via a couple of dtpicker controls.
>
> > I then load up formB this then fires up a couple of sql queries to
> p> opulate the controls on the form, the data is the retrieved and I
> attempt
> t> o populate the 2 DTPicker controls on FormB with a couple of dates from
> t> he recordset like so :-
>
> > dtpRefDate.Value = rs.Fields("ReferredDate").Value, this in turn returns
> a
> r> untime error - 2763 stating that an error occurred in the windows date
> t> ime picker control
>
> > Has anyone come across this ???
>
> > Secondly where have all the DTPicker controls Methods/Properties gone,
> in
> V> B6 I can access things such as dtpicker.date, Month, Time etc etc
>
> > Thanks for any help
>
> >
> This is absolutely no help at all but I have the same problem! Awful isn't
> it? What version is your MSCOMCT2.OCX or whatever the DTPicker control is
> help in? I have the same problem at work under NT4 and here under XP,
> although the disks I installed the VB from are the same in both cases.
>
> John Stout
>