In chapter eleven, pages 287 - 305, the two sub functions 'ControlWord' and 'ControlOutlook' generates a compile error of 'User-defined type not defined'. The error is generated on the statement 'Dim rsContacts As New ADODB.Recordset'

I've double checked the code, copied the code from the site and pasted it in and still receive the same error. I've done the obvious such as checking that my table is set up as per the book and the sample from Wrox as well as ensured that the references in the book are enable and have the priority stacking the same, and again checked in the provided sample database.

The only difference I can find is that in the book the references point to the Access 2007 (beta) and I'm running a more up to date version since the printing of the book.

Any help would be greatly appreciated.

This is old, but just in case someone stumbles upon the same problem - Access 2007 has DAO enabled by default. You need to go set a reference to ADO in Tools > References in the VBA window before this code will work.


Thanks,

Bob Larson, Access MVP