#name? error

[lynn atkinson]

I would like to calculate when a course is due to be
reattended. I have used the date(add) function in a query
and it works fine. However when I try to display this
calculated field on a form I get a #name? error.
How do I do or display this calculation on a form.
The format of my data is as follows
"qualification duration" (ie how long the qualification
lasts eg 6 months, 12 months) and this field is in the
eventsdetails table.
"date attended" is a field in the training record table
Why am I getting the #name error?

 

[prabha]

Hi Lynn,

If it works in your query then there's should be nothing wrong with your
Library References.

Here's an example of how I can repro the same results you have:

Textbox control name = "Text4"; it's control source = #1/1/03#

Textbox control name = "Text5"; it's control source = DateAdd("m",1,[Text4])

If I change Textbox "Text5" control source equal to
=DateAdd("m",1,[Text14444])
I get #Name? because there is no control named "Text14444"

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."



--------------------
| Content-Class: urn:content-classes:message
| From: "lynn atkinson" <[email protected]>
| Sender: "lynn atkinson" <[email protected]>
| Subject: #name? error
| Date: Wed, 18 Feb 2004 07:36:58 -0800
| Lines: 11
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcP2NQu9zRq7Tf2uRj+rATjIywOZGA==
| Newsgroups: microsoft.public.access.forms
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.forms:255687
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.access.forms
|
| I would like to calculate when a course is due to be
| reattended. I have used the date(add) function in a query
| and it works fine. However when I try to display this
| calculated field on a form I get a #name? error.
| How do I do or display this calculation on a form.
| The format of my data is as follows
| "qualification duration" (ie how long the qualification
| lasts eg 6 months, 12 months) and this field is in the
| eventsdetails table.
| "date attended" is a field in the training record table
| Why am I getting the #name error?
|

 

[fredg]

I would like to calculate when a course is due to be
reattended. I have used the date(add) function in a query
and it works fine. However when I try to display this
calculated field on a form I get a #name? error.
How do I do or display this calculation on a form.
The format of my data is as follows
"qualification duration" (ie how long the qualification
lasts eg 6 months, 12 months) and this field is in the
eventsdetails table.
"date attended" is a field in the training record table
Why am I getting the #name error?

things to check for.
1) You mis-spelled a field name and Access can't recognize it.
2) The Name of the control is the same as the name of a field used in
it's exprssion control source.
3) It's always to your advantage, when asking a question of why an
expression fails, to include the actual expression.
4) If all else fails use Access Help...............

#Error? or #Name? appears in a control.

#Error? or #Name? may appear in a control for a number of reasons. To
correct the problem, do the following:

Make sure that the field specified in the control's ControlSource
property hasn't been removed from the underlying table or other record
source.
Check the spelling of the field name in the control's ControlSource
property.
If you specified an expression in the control's ControlSource
property, make sure that there is an equal sign preceding the
expression.
Make sure that there are brackets around references in expressions to
control or field names that include spaces. For example, to subtract a
Shipped Date field from a Required Date field, enter the following
expression: =[Required Date]-[Shipped Date].
If you are using one of the built-in functions, make sure that you're
using the right number of arguments, that the arguments are in the
right order, and that you haven't left out any necessary punctuation.
To determine the correct syntax to use, see the Help topic for the
function you're using.
If you are referring to another control, make sure that you're using
the correct syntax.
Make sure that there isn't a circular reference to a control. For
example, if you specify MyControl in the Name property of a control,
and then type =[A]++[MyControl] in the ControlSource property box
for the control, Microsoft Access can't process the expression.
Make sure that the Access file doesn't contain a missing reference to
a project or library by opening a module in Design view, and clicking
References on the Tools menu. Clear the check box next to any missing
references, and then set the references you want.
If the control is in a data access page and contains an expression
that uses a function, make sure that the function is available in a
data access page.

 

[John Vinson]

I would like to calculate when a course is due to be
reattended. I have used the date(add) function in a query
and it works fine. However when I try to display this
calculated field on a form I get a #name? error.
How do I do or display this calculation on a form.
The format of my data is as follows
"qualification duration" (ie how long the qualification
lasts eg 6 months, 12 months) and this field is in the
eventsdetails table.
"date attended" is a field in the training record table
Why am I getting the #name error?

I don't know. You haven't said what you're doing to get it!

What's the Control Source property of the textbox which is giving the
error? If it's a query field, please post the SQL view of the query.