Share via

MS Visual Basic Error 2455

Anonymous
2016-02-25T15:54:01+00:00

I implemented the CarryOver VBA Code insertion as a Module (http://allenbrowne.com/ser-24.html) in the MS Access 2010 database I am developing.  I have a bug that presents as a MS VB Error 2455 when I insert text into one of the fields.   I have identified the error in the line "varDummy = obj.Properties(strPropName)" of Public Function identified below.  This is the last function of the code from linked Allen Browne CarryOver code.  I did not initially receive this problem, and so realize I have apparently altered something that is not within the code itself (which I believe remains accurately installed).

Any help is appreciated.

Drew

Public Function HasProperty(obj As Object, strPropName As String) As Boolean
    'Purpose: Return true if the object has the property.
    Dim varDummy As Variant

    On Error Resume Next
    varDummy = obj.Properties(strPropName)
    HasProperty = (Err.Number = 0)
End FunctionSince encountering this error and attempting to address it, I am also no longer able to bypass the error and continue inputting data into the database.  The error originally was not named, then was named 2455 with the narrative: "You entered an expression that has an invalid reference to the property Control Source."

Can I get some help here?

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
Answer accepted by question author
  1. Duane Hookom 26,820 Reputation points Volunteer Moderator
    2016-03-01T19:24:30+00:00

    By chance do you have your VBA Options set to Error Trapping->Break on All Errors?

    0 comments No comments

6 additional answers

Sort by: Most helpful
  1. Anonymous
    2016-03-01T23:47:25+00:00

    I will check. It's is possible. I will respond tomorrow. 

    Drew

    0 comments No comments
  2. Anonymous
    2016-03-01T18:55:42+00:00

    Hey DBG,

    Any insight on the problem? 

    Drew

    0 comments No comments
  3. Anonymous
    2016-02-25T16:06:04+00:00

    I added this to the original post. 

    Drew

    0 comments No comments
  4. DBG 11,711 Reputation points Volunteer Moderator
    2016-02-25T16:02:24+00:00

    Hi. Just curious, what is error 2455?

    0 comments No comments