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
 
Top