Member Avatar for jaai

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")
  • 4 Contributors
  • 4 Replies
  • 127 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for monarchmk

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.

Edited by monarchmk because: n/a
Member Avatar for abu taher

need more information. so please share it.

Member Avatar for jaai

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

commented: For solving your own problem.:) +7
Member Avatar for AndreRet

:)

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.