RELATED TO VB6 USING TABLES FROM MS-ACCESS DATABASE
I HAVE A TABLE 'VOUCHERS' CONTAINING FIELD VDATE(datatype: date).
i store 'txtfrom.text' into date_1(datatype:date) as
date_1=txtfrom.text
and
date_2=txtto.text
sql-command -
select vdate from vouchers where vdate between ' " & date_1 & " ' and ' " &date_2& " ';
THIS COMMAND IS SHOWING THE ERROR :' DATA TYPE MISMATCH'
i have tried other forms to like removing ' ' and " & &".....
but it is not working........
pls help me