#name? error

  • Thread starter Thread starter Steve Stad
  • Start date Start date
S

Steve Stad

Whats wrong with this expression in text box on main form reading value of
field [SumOfEmp_Act_Prod_Hrs] in subform named 'qry_Emp_TotalHrsWorked
subform' - it is getting #name? error

=IIf([Forms]![qry_Emp_TotalHrsWorked
subform]![SumOfEmp_Act_Prod_Hrs]>1920,"EMP HOURS ARE GREATER THAN 1920","Emp
Product Hours Less Than 1920")
 
Golfinray - the format is/was blank in the sub form qry_Emp_TotalHrsWorked
subform for 'SumOfEmp_Act_Prod_Hrs'. After reading your reply I tried
changing the format in the subform to general number and standard number. I
also tried the "1920" - still getting the #name? error.

golfinray said:
Are hours in units of time or text? If text your 1920's must be "1920"
--
Milton Purdy
ACCESS
State of Arkansas


Steve Stad said:
Whats wrong with this expression in text box on main form reading value of
field [SumOfEmp_Act_Prod_Hrs] in subform named 'qry_Emp_TotalHrsWorked
subform' - it is getting #name? error

=IIf([Forms]![qry_Emp_TotalHrsWorked
subform]![SumOfEmp_Act_Prod_Hrs]>1920,"EMP HOURS ARE GREATER THAN 1920","Emp
Product Hours Less Than 1920")
Click to expand...
Click to expand...
 
To see if the problem is in your field name of the subform try this:
=IIf([Forms]![qry_Emp_TotalHrsWorked
subform]![SumOfEmp_Act_Prod_Hrs]>1920,"yes","no")
Click to expand...
Click to expand...
Click to expand...
That should tell you if it is finding the field name.
--
Milton Purdy
ACCESS
State of Arkansas


Steve Stad said:
Golfinray - the format is/was blank in the sub form qry_Emp_TotalHrsWorked
subform for 'SumOfEmp_Act_Prod_Hrs'. After reading your reply I tried
changing the format in the subform to general number and standard number. I
also tried the "1920" - still getting the #name? error.

golfinray said:
Are hours in units of time or text? If text your 1920's must be "1920"
--
Milton Purdy
ACCESS
State of Arkansas


Steve Stad said:
Whats wrong with this expression in text box on main form reading value of
field [SumOfEmp_Act_Prod_Hrs] in subform named 'qry_Emp_TotalHrsWorked
subform' - it is getting #name? error

=IIf([Forms]![qry_Emp_TotalHrsWorked
subform]![SumOfEmp_Act_Prod_Hrs]>1920,"EMP HOURS ARE GREATER THAN 1920","Emp
Product Hours Less Than 1920")
Click to expand...
Click to expand...
Click to expand...
 
Golfinray,

I tried the formula you suggested...
=IIf(Forms![qry_Emp_TotalHrsWorked
subform]!SumOfEmp_Act_Prod_Hrs>1920,"Yes","No")

got the same #name? error. could the issue be the space in the subform name
- Access created the name with the space...qry_Emp_TotalHrsWorked subform.

golfinray said:
To see if the problem is in your field name of the subform try this:
=IIf([Forms]![qry_Emp_TotalHrsWorked
subform]![SumOfEmp_Act_Prod_Hrs]>1920,"yes","no")
Click to expand...
Click to expand...
That should tell you if it is finding the field name.
--
Milton Purdy
ACCESS
State of Arkansas


Steve Stad said:
Golfinray - the format is/was blank in the sub form qry_Emp_TotalHrsWorked
subform for 'SumOfEmp_Act_Prod_Hrs'. After reading your reply I tried
changing the format in the subform to general number and standard number. I
also tried the "1920" - still getting the #name? error.

golfinray said:
Are hours in units of time or text? If text your 1920's must be "1920"
--
Milton Purdy
ACCESS
State of Arkansas


:

Whats wrong with this expression in text box on main form reading value of
field [SumOfEmp_Act_Prod_Hrs] in subform named 'qry_Emp_TotalHrsWorked
subform' - it is getting #name? error

=IIf([Forms]![qry_Emp_TotalHrsWorked
subform]![SumOfEmp_Act_Prod_Hrs]>1920,"EMP HOURS ARE GREATER THAN 1920","Emp
Product Hours Less Than 1920")
Click to expand...
Click to expand...
Click to expand...
 
Try this:
forms!form name!subform name!subformcontrolname
I think you are going to have to have the complete reference of form,
formname, subform name, control name instead of form, subformname, control
name. The space should not be the issue.
--
Milton Purdy
ACCESS
State of Arkansas


Steve Stad said:
Golfinray,

I tried the formula you suggested...
=IIf(Forms![qry_Emp_TotalHrsWorked
subform]!SumOfEmp_Act_Prod_Hrs>1920,"Yes","No")

got the same #name? error. could the issue be the space in the subform name
- Access created the name with the space...qry_Emp_TotalHrsWorked subform.

golfinray said:
To see if the problem is in your field name of the subform try this:
=IIf([Forms]![qry_Emp_TotalHrsWorked
subform]![SumOfEmp_Act_Prod_Hrs]>1920,"yes","no")
Click to expand...
That should tell you if it is finding the field name.
--
Milton Purdy
ACCESS
State of Arkansas


Steve Stad said:
Golfinray - the format is/was blank in the sub form qry_Emp_TotalHrsWorked
subform for 'SumOfEmp_Act_Prod_Hrs'. After reading your reply I tried
changing the format in the subform to general number and standard number. I
also tried the "1920" - still getting the #name? error.

:

Are hours in units of time or text? If text your 1920's must be "1920"
--
Milton Purdy
ACCESS
State of Arkansas


:

Whats wrong with this expression in text box on main form reading value of
field [SumOfEmp_Act_Prod_Hrs] in subform named 'qry_Emp_TotalHrsWorked
subform' - it is getting #name? error

=IIf([Forms]![qry_Emp_TotalHrsWorked
subform]![SumOfEmp_Act_Prod_Hrs]>1920,"EMP HOURS ARE GREATER THAN 1920","Emp
Product Hours Less Than 1920")
Click to expand...
Click to expand...
Click to expand...
 
Back
Top