Help with Error: #Name?

[Raj]

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

 

[John Vinson]

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

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

 

[Raj]

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

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

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 Vinson]

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

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