Re: DTPicker




"David Youngblood" <dwy@xxxxxxxxx> wrote in message
news:uLZVf.5339$Od7.1375@xxxxxxxxxxx
<voga@xxxxxxxxxxxxxxxx> wrote...
I have a VB6 project where I am using the ADO with MS Jet. I am using
the DTPicker to set the date. The DataSource is set to the
datPrimaryRS and the DataField is set to the Date field of the
database. When I launch the application, it bombs and returns a
message box saying - Unable to bind to Field or DataMember: 'Date'.
The text boxes all work correctly, but not DTPicker.

What does this mean?

Does your date/time field allow null values. If it does, you might try setting
the DTPicker's CheckBox to True. I believe that if the first record is null
and
you have the CheckBox property set to False you will get that error. That's
not
to say that that's the only cause.

David



It is also not a good idea to have a field named with a data type. A field named
Date is bound to cause trouble (oops, a wee pun) - if not here, then somewhere
along the line. Try renaming the field RecordDate, or ThingyDate, or some such.


.



Relevant Pages

  • Re: DTPicker
    ... datPrimaryRS and the DataField is set to the Date field of the ... database. ... The text boxes all work correctly, but not DTPicker. ... you have the CheckBox property set to False you will get that error. ...
    (comp.lang.basic.visual.misc)
  • Re: DTPicker
    ... The text boxes all work correctly, but not DTPicker. ... ADO without using that stupid checkbox? ... one DTPicker control can handle both Date and Time. ... have the Date and Time in one field in the Jet database. ...
    (comp.lang.basic.visual.misc)
  • Re: DateTime Picker Help
    ... when the Access database is in UK format and the DTPicker control (thanks to ... DTPickFeeDate is the DTPicker Control): ...
    (microsoft.public.vb.general.discussion)