i got a type mismatch run time error 13 in the following line of the load event of my form... pls help me

set rs=db.OpenRecordset("SELECT * FROM STOCK")

Recommended Answers

Can you please share some more of your code, as db and rs definition?
Type of database..
Did you clearly define recordset as ADODB.recordset or DAO.recordset...?
If in preferences is DAO in priority of ADO db type then you could receive this type of error.

Jump to Post

All 4 Replies

Can you please share some more of your code, as db and rs definition?
Type of database..
Did you clearly define recordset as ADODB.recordset or DAO.recordset...?
If in preferences is DAO in priority of ADO db type then you could receive this type of error.

need more information. so please share it.

i gave my table name wrong and so got this error.

commented: For solving your own problem.:) +7

:)

Small things normally causes the worst headaches. Glad you could solve this.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.