MS Access 2016 gives error message, "Compile error: Method or Data Member not found" No idea why

Anonymous
2019-08-09T19:00:52+00:00

I have been asked to handle Social Media for our university Center.  I created an Access 2016 data base and everything seemed fine. However, now I keep getting an error message, and I have no idea how to fix it. The error message says "Compile error: Method or Data Member not found"

After that it says: 

"Option Compare Database

Private Sub Text_Twitter_AfterUpdate()

Me.MemoFieldName.SelStart = 0

Me.MemoFieldName.SelLength = Len(Me.MemoFieldName)

DoCmd.RunCommand acCmdSpelling

End Sub"

Now the Database is broken. :(

First

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} vote

6 answers

Sort by: Most helpful
  1. ScottGem 68,780 Reputation points Volunteer Moderator
    2019-08-12T18:24:55+00:00

    No, changing object names does not automatically change them throughout the database. You can use the Object Dependency feature to try to find wherever they are used. You can also search in VBA for the old names.

    0 comments No comments