Name error but only if first report run?

  • Thread starter Thread starter Sheila D
  • Start date Start date
S

Sheila D

Using Access 2007 - I have a report with a Text Box in the Page Header with
the Control Source =[Electrician] & ":" & [Total] & " Jobs for " & [Date of
Job]
Electrician and Date of Job are fields in the Data Source and Total is a
calculated field in the report header with the Visible property set to No.

If I run this report FIRST after opening the database this results in a Name
error but if I subsequently run any other report then the correct value shows
in the report and the error disappears. Anybody got any idea what could be
causing this.....
Thanks, Sheila
 
Hi Karl

Thanks for your reply. I don't understand why I need to redo the calculation
as it works fine if I open any other report first. Total counts the number of
records; I don't think I can do this in the Page Header can I? Can you
explain a little more for me please.
Sheila

KARL DEWEY said:
The problem is with [Total]. Redo the calculation instead of using
[Total].
--
KARL DEWEY
Build a little - Test a little


Sheila D said:
Using Access 2007 - I have a report with a Text Box in the Page Header with
the Control Source =[Electrician] & ":" & [Total] & " Jobs for " & [Date of
Job]
Electrician and Date of Job are fields in the Data Source and Total is a
calculated field in the report header with the Visible property set to No.

If I run this report FIRST after opening the database this results in a Name
error but if I subsequently run any other report then the correct value shows
in the report and the error disappears. Anybody got any idea what could be
causing this.....
Thanks, Sheila
Click to expand...
Click to expand...
 
Access looks to the Record Source for variables and your [Total] is not there.
--
KARL DEWEY
Build a little - Test a little


Sheila D said:
Hi Karl

Thanks for your reply. I don't understand why I need to redo the calculation
as it works fine if I open any other report first. Total counts the number of
records; I don't think I can do this in the Page Header can I? Can you
explain a little more for me please.
Sheila

KARL DEWEY said:
The problem is with [Total]. Redo the calculation instead of using
[Total].
--
KARL DEWEY
Build a little - Test a little


Sheila D said:
Using Access 2007 - I have a report with a Text Box in the Page Header with
the Control Source =[Electrician] & ":" & [Total] & " Jobs for " & [Date of
Job]
Electrician and Date of Job are fields in the Data Source and Total is a
calculated field in the report header with the Visible property set to No.

If I run this report FIRST after opening the database this results in a Name
error but if I subsequently run any other report then the correct value shows
in the report and the error disappears. Anybody got any idea what could be
causing this.....
Thanks, Sheila
Click to expand...
Click to expand...
Click to expand...
 
Back
Top