user defined type not defined

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top