Welcome to SPN

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

Sign Up Now!

Possible Bug? Me.Recordset doesn't work in Reports... need help.

Discussion in 'Information Technology' started by James, Jul 28, 2006.

  1. James

    James
    Expand Collapse
    Guest

    I'm writing code to fill in data on a report. This is what I've got:

    Public Sub LoadData(childData As DataSource)

    Set Me.Recordset = childData.Dataset

    End Sub

    It steps through .Dataset just fine, when it tries to move on it errors
    out saying "Run Time error '2593' This feature is not available in an
    MDB"

    I use Me.Recordset in forms and it works just fine.

    I've got to View -- Immediate Window and entered: ?me. and it finds
    Recordset as a choice.

    Does anyone have any ideas what's going on? Or have I totally lost
    everyone? Thanks for the help.
     
  2. Loading...

    Similar Threads Forum Date
    Movies Ashdoc's movie review---Mission impossible 5 Rogue nation Theatre, Movies & Cinema Aug 12, 2015
    India Professor Bhullar's release possible after landmark SC judgement Breaking News Jan 21, 2014
    USA UPDATED! Dr. Prabjot Singh, Sikh Professor Attacked in Possible Hate Crime (2 Videos) Breaking News Sep 23, 2013
    A Shabad I came across - possible interpretations Sikh Sikhi Sikhism Aug 28, 2013
    To know God is to Love him, why this is not possible Sikh Sikhi Sikhism Mar 31, 2012

  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    Are the tables linked by chance? It's been a while but I seem to remember
    something about problems with it and linked tables.
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "James" wrote:

    > I'm writing code to fill in data on a report. This is what I've got:
    >
    > Public Sub LoadData(childData As DataSource)
    >
    > Set Me.Recordset = childData.Dataset
    >
    > End Sub
    >
    > It steps through .Dataset just fine, when it tries to move on it errors
    > out saying "Run Time error '2593' This feature is not available in an
    > MDB"
    >
    > I use Me.Recordset in forms and it works just fine.
    >
    > I've got to View -- Immediate Window and entered: ?me. and it finds
    > Recordset as a choice.
    >
    > Does anyone have any ideas what's going on? Or have I totally lost
    > everyone? Thanks for the help.
    >
    >
     
  4. Ken Snell \(MVP\)

    Ken Snell \(MVP\)
    Expand Collapse
    Guest

    Reports do not expose the Recordset property to VBA, so you cannot set /
    change the report's Recordset. You can set the report's RecordSource in the
    report's Open event, but after that the RecordSource and the Recordset are
    fixed and cannot be changed.
    --

    Ken Snell
    <MS ACCESS MVP>


    "James" <jamesburkett@gmail.com> wrote in message
    news:1152300944.531375.178130@s13g2000cwa.googlegroups.com...
    > I'm writing code to fill in data on a report. This is what I've got:
    >
    > Public Sub LoadData(childData As DataSource)
    >
    > Set Me.Recordset = childData.Dataset
    >
    > End Sub
    >
    > It steps through .Dataset just fine, when it tries to move on it errors
    > out saying "Run Time error '2593' This feature is not available in an
    > MDB"
    >
    > I use Me.Recordset in forms and it works just fine.
    >
    > I've got to View -- Immediate Window and entered: ?me. and it finds
    > Recordset as a choice.
    >
    > Does anyone have any ideas what's going on? Or have I totally lost
    > everyone? Thanks for the help.
    >
     

Share This Page