User-defined type not defined.

[nyzja]

Hello! I have this access report that I wrote a while back and it was working until today. Now it's giving me the error message "User-defined type not defined".

I have the following variables in my code:

Dim rsReport As ADODB.Recordset
Dim GroupCounter As Integer
Dim intColumnCount As Integer
Dim lngRgColumnTotal(1 To 6) As Long
Dim lngRgGroupTotal(1 To 4) As Long
Dim lngReportTotal As Long

And intelisense tells me the only data type not recognized is the "ADODB.recordset".


Does anyone have an idea what's wrong here?

Thanks!

 

[Remou]

Have you lost the reference to Microsoft ActiveX Data Objects Library?

 

[nyzja]

Yes, thanks! That explains it.
Any idea of the possible reasons why this happens?
My user has been using the report on a weekly basis.
The reference got lost all of a sudden.

 

[Remou]

Guessing wildly, an update?