#NAME? error on Access
Omacock
Posted messages
2
Status
Member
-
omacock -
omacock -
Hello,
I created a report in Access 2000 with a calculation formula that uses a variable entered in a form: In fact, I open a form where I enter a start date and an end date along with a coefficient, and by validating through a macro (which opens the report and closes the form), the report opens displaying the dates in a title and the result of a formula using the coefficient in a column.
In print preview, the display is almost correct: the titles are displayed, and the results of the formulas are correct on the first page only; on the second page, #NAME? appears where the formula result should be displayed.
When printing: everything is wrong; everywhere I call data from the form, #NAME? appears.
I checked on my machine, and I have the Msowcf.dll file, so I'm lost.
Thank you in advance for your help.
I created a report in Access 2000 with a calculation formula that uses a variable entered in a form: In fact, I open a form where I enter a start date and an end date along with a coefficient, and by validating through a macro (which opens the report and closes the form), the report opens displaying the dates in a title and the result of a formula using the coefficient in a column.
In print preview, the display is almost correct: the titles are displayed, and the results of the formulas are correct on the first page only; on the second page, #NAME? appears where the formula result should be displayed.
When printing: everything is wrong; everywhere I call data from the form, #NAME? appears.
I checked on my machine, and I have the Msowcf.dll file, so I'm lost.
Thank you in advance for your help.
Configuration: Windows XP Internet Explorer 7.0
2 answers
Hello,
It is impossible to provide you with a solution without seeing what you have done. Please upload your compressed database in ZIP format to https://www.cjoint.com/ and post the link.
--
Regards.
Jean-Pierre
It is impossible to provide you with a solution without seeing what you have done. Please upload your compressed database in ZIP format to https://www.cjoint.com/ and post the link.
--
Regards.
Jean-Pierre