V
vtj
The answer to the problem with the inconsistancy that I posted last week has
been solved in that I found a fix. I can not however explain why it is
inconsistant. Apparantly when the report was developed a text box, Text143,
was created. Its use must have involved some sort of action to be taken
BeforeUpdate. The following VBA was in the report: Private Sub
Text143_BeforeUpdate(Cancel AS Integer) Next line:
[FY]![LastofOUT_FISCAL_YR] Next line: End Sub. Setting the 'Has Module'
property to 'No' solves the problem. The person that developed the report
does not know VBA so Access created the coding. I can only assume that the
text box was removed during develpment as it no longer exists in the
documentation provided within Access. But when the Text box was removed, the
code behind it was not removed automatically. The line
[FY]![LastofOUT_FISCAL_YR] was in red so the system knew the code was bad but
it doesn't stop the report from running with some message other than the
'encountered a problem and needs to close' heartbreaking message. And even
then it only happens about 50% of the time. Hope that this proves useful to
others.
been solved in that I found a fix. I can not however explain why it is
inconsistant. Apparantly when the report was developed a text box, Text143,
was created. Its use must have involved some sort of action to be taken
BeforeUpdate. The following VBA was in the report: Private Sub
Text143_BeforeUpdate(Cancel AS Integer) Next line:
[FY]![LastofOUT_FISCAL_YR] Next line: End Sub. Setting the 'Has Module'
property to 'No' solves the problem. The person that developed the report
does not know VBA so Access created the coding. I can only assume that the
text box was removed during develpment as it no longer exists in the
documentation provided within Access. But when the Text box was removed, the
code behind it was not removed automatically. The line
[FY]![LastofOUT_FISCAL_YR] was in red so the system knew the code was bad but
it doesn't stop the report from running with some message other than the
'encountered a problem and needs to close' heartbreaking message. And even
then it only happens about 50% of the time. Hope that this proves useful to
others.