I hope the title says it well enough. The application I wrote was running. Users were entering data - it worked fine. Then I had to do some changes to the structure. After changing the structure I worked my way back up doing changes to the main data entry form and code. Just as I seemed to get it working, it collapsed into a bunch of errors". All of these errors were in the "+Me" object in the main data entry form. The errors still show up even when I comment out all the code behind the form. The errors all have this pattern:
You entered an expression that has an invalid reference to the property acHiddenCurrentPage - long.
You " " " " " " " " " " " ConnectControl - control.
You " " " " " " " " " " " LogicalPageHeight - Long
You " " " " " " " " " " " Resync Command - string.
And so on and so forth. I looked in the original version before the structure changes. Many (if not all) of the error messages are there, also! But the earlier version works!? I tried commenting out all of the code behind the form in my newer version but the errors are still there! I have been checking my references. They are:
Visual Basic for applications
MS 9.0 Object Library
OLE Automation
MS ActiveX Data Objects 2.1 Library
MS Visual Basic for Applications extensibility 5.3
MS Office 9.0 Object Library
MS Forms 2.0 Object Library
MS ActiveX Data Objects Recordset 2.1 Library
Are the references the cause? Is it something else? Any recommendations for how to trouble-shoot this?
Thanks for your Help!
StephenS
You entered an expression that has an invalid reference to the property acHiddenCurrentPage - long.
You " " " " " " " " " " " ConnectControl - control.
You " " " " " " " " " " " LogicalPageHeight - Long
You " " " " " " " " " " " Resync Command - string.
And so on and so forth. I looked in the original version before the structure changes. Many (if not all) of the error messages are there, also! But the earlier version works!? I tried commenting out all of the code behind the form in my newer version but the errors are still there! I have been checking my references. They are:
Visual Basic for applications
MS 9.0 Object Library
OLE Automation
MS ActiveX Data Objects 2.1 Library
MS Visual Basic for Applications extensibility 5.3
MS Office 9.0 Object Library
MS Forms 2.0 Object Library
MS ActiveX Data Objects Recordset 2.1 Library
Are the references the cause? Is it something else? Any recommendations for how to trouble-shoot this?
Thanks for your Help!
StephenS