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'm having difficulty with a field on a form which calculates the # days pending by comparing the open_dt with the closed_dt. The calculation is performed with a module function and works perfectly for all other reports.
Each time I open the database and the form the #Name? error appears in the # days pending form field. The only way I can get the calculation field to work properly is to delete the field from the form and re-add it. However, as soon as I close and reopen the database the error appears again.
I'm using a split database. I added two fields to the backend database about the time this problem started to occur. The field names used in the calculation are the same, and as I mentioned before, all other reports using the same calculation work just fine.
Any advice would be appreciated.
Walt N
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.
![](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(284.8, 62%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Can you share the function, expression in the Control Source, name of the text box, sample values, and data types?
Typically you will see the #Name? error if the name of the control is also the name of a field in the record source and the Control Source begins with "=".
As I stated previously:
Typically you will see the #Name? error if the name of the control is also the name of a field in the record source and the Control Source begins with "=".
You have a field name "Days Pending" and a control named "Days Pending". Also, your Control Source begins with "=". Try change the name of the control to "txtDaysPending".
Did you check to see if the changes stuck? This could be an issue with the "Name AutoCorrect Options" being on. I typically uncheck all of these options in Access Options->Current Database.
Duane,
I've done a few compact and repairs this week but the error persisted. I did not recompile the code for the module function.
I went to a backup copy for the front-end database and relinked to the back-end using the Link Table Manager utility. Then I reworked the form by removing the unwanted fields and adding the new fields and edit lists.
The form seems to be working again but I'm not sure why.
Fingers crossed for now.
Thanks for your help,
Walt N
Hey Duane,
The function is one I found here running a module called WorkingDaysMod called WorkingDays2. It uses a table of holidays along with the opened date and closed date to compute the # days pending for each incident.
The expression in the control source is: =WorkingDays2([Opened Date],NZ([Closed Date],Date()))
The name field Text Box is: Days Pending
The name of the Control is: Days Pending
The data type is a General Number (samples 1,2,3,........)
The label on the form field is: # Days Pending
I have a field in my table called "Days Pending" which at the outset I wanted to use to store the value. Since then I've learned it is better to do the computation when the report is generated rather than attempt to store it.
Thanks again for your help.
Sincerely,
Walt N