recordset type mismatch

[abenitez77]

I am using ms access 2007 and i am getting this error when i run this code:

code:
Dim rst As Recordset
Dim db As Database
Dim temp As String
Dim svrname As String

Set db = CurrentDb
Set rst = Recordset

Set rst = db.OpenRecordset("tbl_AS_ReportClms", dbOpenDynaset)


error:
Runtime error 13
type mismatch

 

[MajP]

try this after ensuring a reference to DAO?

dim rst as dao.recordset
dim db as dao.database

a recordset can be either aodb.recordset or dao.recordset. If you do not specify access picks the first one listed in the references.

 

[danvlas]

I would delete this first:
Set rst = Recordset



Daniel Vlas
Systems Consultant

 

[boblarson]

Yep, both danvlas and MajP have a part of it. Put them both together and you should be on your way.

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com

 

[abenitez77]

I didn't know that ... Thanks I keep that in mind next time and adjust my code this time.