Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

user defined type not defined

Discussion in 'Information Technology' started by Ed H, Oct 27, 2005.

Tags:
  1. Ed H

    Ed H
    Expand Collapse
    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.
     
  2. Loading...

    Similar Threads Forum Date
    After FIR, Social Media Users Wary of Offensive Jokes on Sardars Information Technology Oct 2, 2013
    USA US govt secretly collecting data on millions of Verizon users: Report Breaking News Jun 6, 2013
    using spiritual name as a username Questions and Answers Aug 23, 2012
    Audience of 3 Million Users Receiving Anti-Sikh Messages Hard Talk Sep 17, 2010
    General How can I change my username ? Hard Talk Sep 4, 2010

  3. Ricky Hicks MVP

    Ricky Hicks MVP
    Expand Collapse
    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" wrote:

    > 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.
     
  4. ·®·®

    ·®·®
    Expand Collapse
    Guest

    "Ed H" <EdH@discussions.microsoft.com> дÈëÓʼþ
    news:225FA379-21F2-41D9-8CB3-5A1A3F4495D1@microsoft.com...
    > 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.
     

Share This Page