Hi,

I would like some advice on Visual Basic Access. I have put the following bits of code in VB.

Option Compare Database
Option Explicit

Dim RS As New ADODB.Recordset

But for some reason it is coming back with an error saying that it can't recognise it. Are there particular settings or declarions that need to be put in place before the code will work?

Hope you can help.

Cheers

Dave