access.report User Type not defined

[EliseFreedman]

I am attempting to use an ado recordset as the source for a report. The code I am using is taken from the programmingMSaccess.com website.
One of the lines is
Dim rpt1 as access.report
I am getting the error User Type Not Defined.
I suspect that it is due to a reference not being set. Can anyone advise which reference I am missing

 

[Kotaro24]

You probably need a reference set for Microsoft Access.
Go into (and I'm guessing VB6 here) Project>References and choose 'Microsoft Access x.0 library' (x will be a number representing your current version of Access).

Incidentally, both your PC and the PC(s) you run the program on will have to have this same version of MS-Access installed in order to avoid an 'Invalid reference' error.