Results 1 to 2 of 2
  1. #1
    eazy4me is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2013
    Posts
    1

    Error: This Object Doesn't Contain The Automation Object 'recordsetclone'.

    I'm not really familiar with Access, but after update the database from Office 1997 to office 2010 i got an error everytime i click a button. The error is:
    This object doesn't contain the automation object 'RecordsetClone'.

    Please help me.
    This is the code:

    Private Sub Knop148_Click()
    On Error GoTo Err_Knop148_Click


    DoCmd.Close

    Exit_Knop148_Click:
    Exit Sub

    Err_Knop148_Click:
    MsgBox Err.Description
    Resume Exit_Knop148_Click

    End Sub
    Private Sub Clientselectie_Click()
    On Error GoTo Err_Clientselectie_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "Klanten"

    stLinkCriteria = "[Klant-ID]=" & Me![Klant-ID]
    DoCmd.Close
    DoCmd.OpenForm stDocName, , , stLinkCriteria

    Exit_Clientselectie_Click:
    Exit Sub

    Err_Clientselectie_Click:
    MsgBox Err.Description
    Resume Exit_Clientselectie_Click

    End Sub
    Private Sub Nieuweklant_Click()
    On Error GoTo Err_Nieuweklant_Click
    Dim stDocName As String


    stDocName = "Client"
    DoCmd.Close
    DoCmd.OpenForm stDocName
    DoCmd.GoToRecord , , acNewRec

    Exit_Nieuweklant_Click:
    Exit Sub

    Err_Nieuweklant_Click:
    MsgBox Err.Description
    Resume Exit_Nieuweklant_Click

    End Sub
    Sub Keuzelijst_met_invoervak153_AfterUpdate()
    ' De record zoeken die overeenkomt met het besturingselement
    Me.RecordsetClone.FindFirst "[NAAM] = " & Me!["Keuzelijst met invoervak153"]
    Me.Bookmark = Me.RecordsetClone.Bookmark
    End Sub

    Private Sub CLIENTNAAM_ZOEKEN_Click()
    On Error GoTo Err_CLIENTNAAM_ZOEKEN_Click


    Screen.PreviousControl.SetFocus
    DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

    Exit_CLIENTNAAM_ZOEKEN_Click:
    Exit Sub

    Err_CLIENTNAAM_ZOEKEN_Click:
    MsgBox Err.Description
    Resume Exit_CLIENTNAAM_ZOEKEN_Click

    End Sub
    Sub Keuzelijst_met_invoervak159_AfterUpdate()
    ' De record zoeken die overeenkomt met het besturingselement
    Me.RecordsetClone.FindFirst "[Klant-ID] = " & Me![Keuzelijst met invoervak159]
    Me.Bookmark = Me.RecordsetClone.Bookmark
    End Sub

    Private Sub Nieuwe_Client_Toevogen_Click()
    On Error GoTo Err_Nieuwe_Client_Toevogen_Click

    Dim stDocName As String

    stDocName = "Nieuwe Klanten"
    DoCmd.Close
    DoCmd.OpenForm stDocName
    DoCmd.GoToRecord , , acNewRec

    Exit_Nieuwe_Client_Toevogen_Click:
    Exit Sub

    Err_Nieuwe_Client_Toevogen_Click:
    MsgBox Err.Description
    Resume Exit_Nieuwe_Client_Toevogen_Click

    End Sub

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    when are you getting the error, you have a bunch of different events in that list of code?

    If you can define where it's breaking put in debug.print messages within the section it's breaking to find out which line it's breaking on.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 04-10-2012, 08:48 AM
  2. Replies: 0
    Last Post: 12-15-2011, 11:57 AM
  3. Replies: 6
    Last Post: 11-18-2011, 03:46 PM
  4. Replies: 3
    Last Post: 11-02-2010, 10:14 AM
  5. Replies: 1
    Last Post: 08-05-2010, 12:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums