B
brian
I have an application developed in Access 2000 that does not work on a
machine running Access 2003. This application commonly uses the
report's PageHeader_Format to set a public variable, which is
referenced in a header textbox using =[variableName]. For example, one
report module contains:
Public rptTrial
Private Sub PageHeader_Format(...)
rptTrial = 1
End Sub
A textbox in the header has a Control Source of: =[rptTrial]
When I run the report, the textbox shows "#Name?". If I change the
=[rptTrial] to =[rptTrialX] and run the report, I am prompted for a
parameter value. Therefore, I know Access understands that rptTrial is
defined, but for some reason is not using its value.
I thought perhaps Access had changed between 2000 and 2003, but I have
2 laptops that are running the identical version of Access 2003
(11.6566.6568 SP2) and the same database file -- one works and the
other doesn't. The one that works is running XP Professional 2002 SP2
and the one that doesn't work is running XP MediaCenter 2002 SP2.
machine running Access 2003. This application commonly uses the
report's PageHeader_Format to set a public variable, which is
referenced in a header textbox using =[variableName]. For example, one
report module contains:
Public rptTrial
Private Sub PageHeader_Format(...)
rptTrial = 1
End Sub
A textbox in the header has a Control Source of: =[rptTrial]
When I run the report, the textbox shows "#Name?". If I change the
=[rptTrial] to =[rptTrialX] and run the report, I am prompted for a
parameter value. Therefore, I know Access understands that rptTrial is
defined, but for some reason is not using its value.
I thought perhaps Access had changed between 2000 and 2003, but I have
2 laptops that are running the identical version of Access 2003
(11.6566.6568 SP2) and the same database file -- one works and the
other doesn't. The one that works is running XP Professional 2002 SP2
and the one that doesn't work is running XP MediaCenter 2002 SP2.