Date and time picker control 6.0 (SP4)

[jaydeebe]

How might I get the user to input the date and time easily. I have tried having seperate controls for time and date but can't combine the values to save in one date/time field -

DoCmd.RunSQL "INSERT INTO tblbookings ([StartDate],_[EndDate],[UserID],[ResID],[FileLocation]) VALUES _(txtStartDate & ' '& txtStartTime,txtEndDate & ' ' &_ txtendTime, txtUserID ,cboAvailRes, txtFileLoc);"

gives error due to type conversion error.

I have tried custom format for the DT picker of dd/MM/yyyy hh:mm but this is not a friendly way of inputing.

Any ideas anyone?

 

[PHV]

Something like this ?
DoCmd.RunSQL "INSERT INTO tblbookings ([StartDate],_[EndDate],[UserID],[ResID],[FileLocation]) VALUES (#" _
& txtStartDate & "#+#" & txtStartTime & "#,#" & txtEndDate & "#+#" & txtendTime & "#," _
& txtUserID & "," & cboAvailRes & ",'" & txtFileLoc & "')"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244