user defined type not defined

G

Guest

I'm trying to convert my first ACCESS 97 project to Access 2003. I'm
receiving the above error when I try to compile a module. It stops on the
following:

Private Function CreateQueryResultTable(rsSource As Recordset, TargetTable
As String, ResultCols As Integer) As String

I think the bigger question is, "Does a paper exist that identifies the
differences between Access 97 and Access 2003 or likewise, VBA with VB.NET?"

I'm new at this and I'm thinking it is Recordset that is actually the issue.
I have seen reference to ADODB.Recordset, but chaning it to that does not
make a difference.
 
G

Guest

More than likely you are using a DAO method ...
Change it to:

Private Function CreateQueryResultTable(rsSource As DAO.Recordset,
TargetTable
As String, ResultCols As Integer) As String

Also .. make sure that the Microsoft DAO 3.6 Object Library is enabled in
the application ...

R. Hicks
 
·

·®·®

Ed H said:
I'm trying to convert my first ACCESS 97 project to Access 2003. I'm
receiving the above error when I try to compile a module. It stops on the
following:

Private Function CreateQueryResultTable(rsSource As Recordset, TargetTable
As String, ResultCols As Integer) As String

I think the bigger question is, "Does a paper exist that identifies the
differences between Access 97 and Access 2003 or likewise, VBA with VB.NET?"

I'm new at this and I'm thinking it is Recordset that is actually the issue.
I have seen reference to ADODB.Recordset, but chaning it to that does not
make a difference.
 

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

Top