This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I am still having an idiot problem with page numbers on a simple report.
In the report footer i have a text field with the following as the control source:
=[Page] & " of " & [Pages]
Directly after entering the above, I can run the report and the page numbers appear fine.
I save the report and close the database, but the next time that i go into the database,
and run the report, it cites
#Name? instead of the page numbers :(
I am running access 2007 on WIN XP pro, service pack 3
I even started all over again and used Format tab>Controls Group>Page number,
but this resulted in the same problemL
I previously had a field, in a table, name “Last page” (this was imported data). I have since,
renamed that field and saved the database – so I have no fields named “page”, which I understand,
can cause problems.
Can anyone help? Thank you
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
I'd suggest turning off Name Autocorrect (deleting the stored name data in the process) and compacting the database. I'm guessing that there's some memory of a "Page" field in the autocorrect tables.
And failing that, perhaps a Decompile might help.
I'd suggest turning off Name Autocorrect (deleting the stored name data in the process) and compacting the database. I'm guessing that there's some memory of a "Page" field in the autocorrect tables.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
Hello,
I am still having this problem myself and i cannot figure out why.
In the report footer i have a text field with the following in the control source:
=[Page] & " of " & [Pages]
Directly after entering the above, i can run the report and page number appears fine.
I save the report and close the database, but the next time that i go into the database,
the report cites
#Name? instead of the page:(
I am running access 2007 on WIN XP pro service pack 3
Can anyone help? thank you
It sounds to me like you have something, somewhere that is named PAGE or PAGES. That will just kill everything for this. If you can't find where it is, then you might consider using the FREE V-TOOLS which has a tool called TOTAL DEEP SEARCH which might be able to find where you have this being used.
Hello,
I am still having this problem myself and i cannot figure out why.
In the report footer i have a text field with the following in the control source:
=[Page] & " of " & [Pages]
Directly after entering the above, i can run the report and page number appears fine.
I save the report and close the database, but the next time that i go into the database,
the report cites
#Name? instead of the page:(
I am running access 2007 on WIN XP pro service pack 3
Can anyone help? thank you