Error messge for DTPicker value. 
Author Message
 Error messge for DTPicker value.
I got error message "Data type mismatch...." with the following sql
statement:

sql = "select * from tablename where sendDate = " & "'" &
DTPicker1.value & "'"

where sendDate is a data type of Date/Time in Access.

Any suggestions? TIA

Leo



Wed, 26 Dec 2001 03:00:00 GMT
 Error messge for DTPicker value.

Try using #'s to set off the DTPicker value instead of single quotes.
For example:

sql = "select * from tablename where sendDate = " & "#" &
DTPicker1.value & "#"

-Dan Beacom


Quote:
>I got error message "Data type mismatch...." with the following sql
>statement:

>sql = "select * from tablename where sendDate = " & "'" &
>DTPicker1.value & "'"

>where sendDate is a data type of Date/Time in Access.

>Any suggestions? TIA

>Leo



Wed, 26 Dec 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. DTPicker with null value

2. ?? How to set DTPicker Value to current date??

3. DTPicker with null value

4. Passing date value to return a recordset - DTPicker??

5. DTPicker Value Problem

6. help me with this error messge

7. Error messge whne i backup

8. ORACLE Error Messge

9. Error messge

10. DtPicker and recordset error

11. Messge to BP Margolin

12. hide sql server system messge


 
Powered by phpBB® Forum Software