I have inherited a project on which at least 3 other people have hacked code into entirely without comments.
While I know the database side of Access in and out, I am less solid on the reports interface. I am frequently running into cases now where there is a TextBox that is currently correctly printing data out to the screen.
This is good. Except that we need to change what it outputs.
The name that is in the textbox for the data is say "ExampleVar". Now, that name doesn't show up in any linked table/column names, no temp table/column names, nor does it show up in a global search of all of the code.
If I change it so that it says "=[ExampleVar] +[ColumnName]" (no quotes) - then it fails and says that it doesn't know "ColumnName" even though it does. I can then add the table to it ([TableName]![ColumnName]) and it then says it doesn't know the table.
From there, if I back off and go back to "=[ExampleVar]" it will fail and not know that. Then if I go back to exactly what it was ("ExampleVar") it will fail.
So then if I go in through the data control and try to find it, it isn't there.
But, if I then find another report that has the same thing working like this one originally did (like an Email or PDF generating report), then I can copy and paste what it has (even though all it says is "ExampleVar" which is exactly what my non-working one has) and then it works.
Where can I look to find where this value is coming from? Why won't it recognize any other values that are valid (there is a text box also on the section of the report that has "ColumnName" in it and it works fine - I can also change that to "=[ColumnName] + 1" and it still works fine)?
How can I easily track down where the TextBox is getting its data from?
While I know the database side of Access in and out, I am less solid on the reports interface. I am frequently running into cases now where there is a TextBox that is currently correctly printing data out to the screen.
This is good. Except that we need to change what it outputs.
The name that is in the textbox for the data is say "ExampleVar". Now, that name doesn't show up in any linked table/column names, no temp table/column names, nor does it show up in a global search of all of the code.
If I change it so that it says "=[ExampleVar] +[ColumnName]" (no quotes) - then it fails and says that it doesn't know "ColumnName" even though it does. I can then add the table to it ([TableName]![ColumnName]) and it then says it doesn't know the table.
From there, if I back off and go back to "=[ExampleVar]" it will fail and not know that. Then if I go back to exactly what it was ("ExampleVar") it will fail.
So then if I go in through the data control and try to find it, it isn't there.
But, if I then find another report that has the same thing working like this one originally did (like an Email or PDF generating report), then I can copy and paste what it has (even though all it says is "ExampleVar" which is exactly what my non-working one has) and then it works.
Where can I look to find where this value is coming from? Why won't it recognize any other values that are valid (there is a text box also on the section of the report that has "ColumnName" in it and it works fine - I can also change that to "=[ColumnName] + 1" and it still works fine)?
How can I easily track down where the TextBox is getting its data from?
