Help with Error: #Name?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this formula in a text box =(13-Month([date_resolved])). The problem
is when the user scrolls through the records they data changes to this
#Name?. Can someone shed some light on why this might be happening..
Thank you
 
I have this formula in a text box =(13-Month([date_resolved])). The problem
is when the user scrolls through the records they data changes to this
#Name?. Can someone shed some light on why this might be happening..
Thank you
Click to expand...

A couple of possibilities. Is there a field named [date_resolved] in
the Form's recordsource? If not, then the expression has no meaning
and will display as #Name?.

Or, you may have a missing VBA reference causing the Month() function
to fail. This isn't uncommon! Open any module in design view, or open
the VBA editor by typing Ctrl-G. Select Tools... References from the
menu. One of the .DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
John,
Yes, [date_resolved] is in the forms recordsource. I tried what you
suggested but I am still getting the same error any other thing I can try..
Thanks

John Vinson said:
I have this formula in a text box =(13-Month([date_resolved])). The problem
is when the user scrolls through the records they data changes to this
#Name?. Can someone shed some light on why this might be happening..
Thank you
Click to expand...

A couple of possibilities. Is there a field named [date_resolved] in
the Form's recordsource? If not, then the expression has no meaning
and will display as #Name?.

Or, you may have a missing VBA reference causing the Month() function
to fail. This isn't uncommon! Open any module in design view, or open
the VBA editor by typing Ctrl-G. Select Tools... References from the
menu. One of the .DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
John,
Yes, [date_resolved] is in the forms recordsource. I tried what you
suggested but I am still getting the same error any other thing I can try..
Thanks
Click to expand...

Hrm. Try

=(13-Month(CDate([date_resolved])))

just to coerce the contents of the textbox to Date/Time.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top