Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

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.
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page