Data Type Conversion error

G

Guest

I enter the procedures and module on Article ID 209871: "How to create
password protected Form of Report" in the Northwind Sample and I received the
error on the above subject. I also used the same codes in my Form and it
gave the same error.

I browse the newsgroup and change the Dim rs As DAO.Recordset and Dim db As
DAO.Recordset. I tested both without the DAO and with the DAO in it and it
gave the same error.

I am using Access 2003.
 
G

Graham Mandeno

Well, it's hard to diagnose the problem in your code if we have to imagine
what it contains! I suggest you post the code that is giving you the error.

However, I will hazard a guess that your variable "db" is supposed to be a
Database, not a Recordset, so try changing:
Dim db As DAO.Recordset
to
Dim db As DAO.Database
 

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

Error with automation - Access 2007 creating Outlook calendar appo 1
Annoying Data Type Conversion Error 1
Concencate Emails, Error type declaration does not match 8
Password protected report problem 4
error referencing a subform control 2
Error 3144 - Syntax Error in UPDATE Statement 1
3134 error 2
Running SQL statements in VBA 4

Top