DAO Parameter Question

V

Vicki

When I open the form I want to scroll through the table
and look to see if a specific field has a value in it.
When it opens I get "Compile error: Can't find project or
library" and dbOpenDynaset is highlighted. I've verified
that DAO 3.6 is checked in the reference library. Checked
Help and my syntax appears to be correct. Any ideas?
Thanks for the help.
Here's my DAO setup code -

Open Compare Database
Option Explicit

Dim db as DAO.Database
Dim rs as DAO.Recordset


Set db = CurrentDb()
Set rs = db.OpenRecordset("tblName", dbOpenDynaset)
 
A

Alex Dybenko

check other references, probably you have missing one. and remove unused
references
 
G

Guest

Thanks, Alex, you were right. The reference library
listed an obsolete ActiveX control.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate Function 6
Using "OpenRecordset" on Linked Table Issue 4
user defined not defined 1
Auto Email Help 3
Compile Error: Type Mismatch 3
can't open recordset 2
Add record with ODBC Connection 3
ADP Update Table Code 5

Top