runtime error 438 after importing project

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • serviceman via AccessMonster.com
    #1

    runtime error 438 after importing project

    Me Again,
    I just imported a working project from an SQL server based setup to an Access
    based setup, and now this code is giving me a 'runtime error 438 not
    defined' message :

    Private Sub Combo108_AfterU pdate()
    ' Find the record that matches the control.
    Dim rs As Object

    Set rs = Me.Recordset.Cl one
    rs.Find "STUDENT_ID = " & Str(Nz(Me![Combo108], 0)) <----bookmark of
    error
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark
    DoCmd.requery "Combo108"
    End Sub

    I pretty sure this is a screwed up reference, but I can't seem to find it.
    Any Ideas?

    --
    A $300 dollar picture tube will protect a 10 cent fuse by blowing first-
    Murphy

    Message posted via http://www.accessmonster.com
    Tags: None
    • serviceman via AccessMonster.com
      #2
      Re: runtime error 438 after importing project

      Sorry,
      Make that 'Runtime erros 438: Object doesn't support this property or method'.
      ...

      serviceman wrote:[color=blue]
      >Me Again,
      >I just imported a working project from an SQL server based setup to an Access
      >based setup, and now this code is giving me a 'runtime error 438 not
      >defined' message :
      >
      >Private Sub Combo108_AfterU pdate()
      > ' Find the record that matches the control.
      > Dim rs As Object
      >
      > Set rs = Me.Recordset.Cl one
      > rs.Find "STUDENT_ID = " & Str(Nz(Me![Combo108], 0)) <----bookmark of
      >error
      > If Not rs.EOF Then Me.Bookmark = rs.Bookmark
      > DoCmd.requery "Combo108"
      >End Sub
      >
      >I pretty sure this is a screwed up reference, but I can't seem to find it.
      >Any Ideas?
      >[/color]

      --
      A $300 dollar picture tube will protect a 10 cent fuse by blowing first-
      Murphy

      Message posted via AccessMonster.c om
      http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200605/1

        Comment

        • serviceman via AccessMonster.com
          #3
          Re: runtime error 438 after importing project

          Got it.
          It isn't 'Find' but rather 'FindFirst'....

          serviceman wrote:[color=blue]
          >Sorry,
          >Make that 'Runtime erros 438: Object doesn't support this property or method'.
          >..
          >[color=green]
          >>Me Again,
          >>I just imported a working project from an SQL server based setup to an Access[/color]
          >[quoted text clipped - 14 lines][color=green]
          >>I pretty sure this is a screwed up reference, but I can't seem to find it.
          >>Any Ideas?[/color]
          >[/color]

          --
          A $300 dollar picture tube will protect a 10 cent fuse by blowing first-
          Murphy

          Message posted via AccessMonster.c om
          http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200605/1

            Comment

            Previous template Next
            Working...