Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Picker Please help!!!!
- Thread starter lucyv
- Start date
Are you using DAO?
Try This....
Set rs = db.OpenRecordset("TableName",dbOpenDynaset)
With rs
DTPicker1.Value = !fldBeginDate
End With
rs.Close
Set rs=Nothing
Note:
If you are trying to find a specific Date to load to the DatePicker Control... Try to query before loading it to the control.![[bigsmile]](/data/assets/smilies/bigsmile.gif "[bigsmile] [bigsmile]")
Try This....
Set rs = db.OpenRecordset("TableName",dbOpenDynaset)
With rs
DTPicker1.Value = !fldBeginDate
End With
rs.Close
Set rs=Nothing
Note:
If you are trying to find a specific Date to load to the DatePicker Control... Try to query before loading it to the control.
Does rs.fields("fldBeginDate"
.value contain a legitimate date format?
Try
=CDate(rs.fields("fldBeginDate".value)
or
=DateValue(rs.fields("fldBeginDate".value)
If this doesn't work then I would say that the field doesn't contain a date, or that other code following this code (in the same proceedure or in a event somewhere else) is causing another change to the set value or defaulting back.
.value contain a legitimate date format?Try
=CDate(rs.fields("fldBeginDate"
.value) or
=DateValue(rs.fields("fldBeginDate"
.value)If this doesn't work then I would say that the field doesn't contain a date, or that other code following this code (in the same proceedure or in a event somewhere else) is causing another change to the set value or defaulting back.
- Thread starter
- #5
- Status
