Recordset run type error 13

  • Thread starter Thread starter Bill
  • Start date Start date
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
 
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
Acc2000: Recordset not updating 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 2450 2
Error Accessing Database 1

Back
Top