By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,225 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Error Recovery

P: n/a
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

Mar 5 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
If this line gives the error:
Set GetRec = IECDB.OpenRecordset(strSQL)
how did you declare GetRec?

If you used:
Dim GetRec As Recordset
try:
Dim GetRec As DAO.Recordset
Explanation:
http://allenbrowne.com/ser-38.html

If you open table b_Invoice in design view, what data type is the BEDocNo
field? If text you need extra quotes:
strFilter = "BEDocNo = """ & frmBEJob.txtJobno & """"
Explanation:
http://allenbrowne.com/casu-17.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<hu*****@gmail.comwrote in message
news:11**********************@h3g2000cwc.googlegro ups.com...
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
Mar 5 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.