Hi,

the reference is called:
Microsoft ActiveX Data Objects x.x library

if that's installed and you still get errors, check the tablenames and
fieldnames in the expression. They should match the existing table in your
database.
--
Kind regards
Noëlla


"cjgav" wrote:

Hi
I've tried to do this but there is no ADODB LIBARY listed !

"Noëlla Gabriël" wrote:

Hi,

You need to have a reference to the ADODB library in your project. Open a
module (any module) , click tools - references and check the ADODB reference
lib. I don't have my own computer now, so can't have a quick look now, but
you'll find it :-)
--
Kind regards
Noëlla


"cjgav" wrote:


Hi
Thank you for your help this looks very much like it.
I do not understand vb very well at all do i need to edit function as it
stands there seems to be a compile error on line rst.open