Recordset run type error 13

B

Bill

Hi,

My Code is as follows:-

Dim dbMyDB As DAO.Database
Dim rsMyRS As Recordset
Dim fldMyfield As Field, lngRecCount As Long
Dim ingInitial As Long

Set dbMyDB = CurrentDb
Set rsMyRS = dbMyDB.OpenRecordset("Holidays")

when I get to last line I get a run time error.

Can you help me what is wrong with my code.

Thanks

Bill
 
K

Ken Snell [MVP]

Likely you have both ADO and DAO libraries set as references in your
database. Disambiguate the Dim .. Recordset line:

Dim rsMyRS As DAO.Recordset
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with write DAO 1
Run-Time 13 Error - Type Mismatch 1
Runnign a QueryDef from CmdBtn on a form 4
Function does not work 2
Run-time Error 13 - Type mismatch 1
Run Time Error - 13 Type Mismatch and Don't know why ??? 2
Run-time error 2450 2
VBA for Dependents shortcut menu 0

Top