A family of Microsoft relational database management systems designed for ease of use.
By chance do you have your VBA Options set to Error Trapping->Break on All Errors?
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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?
A family of Microsoft relational database management systems designed for ease of use.
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.
Answer accepted by question author
By chance do you have your VBA Options set to Error Trapping->Break on All Errors?
I will check. It's is possible. I will respond tomorrow.
Drew
Hey DBG,
Any insight on the problem?
Drew
I added this to the original post.
Drew
Hi. Just curious, what is error 2455?