toughest general question ever(date/time picker)!

i am using MS ACCESS as my database and a date/time picker. the problem is if the value of the date/time picker is at 12:00:00 the it returns only the date.
i.e
if the value of btpTo is 01/01/2004 12:00:00 am it only retuns 01/01/2004 which is the date. the problem is i nee to get the exact date/time. any one has an idea on this?! hehehe





to be clear.

my database has:

fieldname: mydt
data type: date/time format: general date

my code in VB:

VB Code:

rs.open "select * from myDB where id = 1",cn,1,1
rs.addnew
rs!mydt = "12/12/2004 12:00:00 am"
rs.update

result when saved into dbase.

mydt(fieldname)
12/12/2004



time is missing! it should be 12/12/2004 12:00:00 am

try this forum http://www.vbforums.com/forumdisplay.php?s=&forumid=3

sorry for the comment about ms access. what i mean is that i am having problems with datetimepicker. if the date is 01/01/2004 12:00:00 am it only returns 01/01/2004 time is missing what can i do

As we know "01/01/2004 12:00:00" and "01/01/2004" are one and the same. Whats your porblem if it does not return time then?

You could just fill in the blank. See if the time is there, if it's not then add 12:00:00 to the string.

i need the whole values in my report. it's not a good idea if i just give the date and not time.

try this

VB Code:

MsgBox Format(DTPicker1.Value, "MM/DD/YYYY HH:MM:SS AM/PM")