|
Hi i m huzain
i m using vb and ms-access and strFilter command also.i got a error
for an data type mismatch
error the code below is there
Case "BE_Invoice"
strSQL = "Select BEDocNo,Inv_Sr_No,Inv_No from b_Invoice"
strFilter = "BEDocNo=" & frmBEJob.txtJobno
this code contain the table name is an b_invoices it should having an
fields like
BDcoc,Inv_Sr_No,Inv_no
this above fields daty type is an "Text"
i got a error for an "3464 Data type mismatch error"
whenever the i to press the Debug it should go for an
module under below
Set GetRec = IECDB.OpenRecordset(strSQL)
the error will goes to this code
please clear me
| 
