If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#name? error
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") |
#2
|
|||
|
|||
#name? error
Are hours in units of time or text? If text your 1920's must be "1920"
-- Milton Purdy ACCESS State of Arkansas "Steve Stad" wrote: 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") |
#3
|
|||
|
|||
#name? error
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" wrote: Are hours in units of time or text? If text your 1920's must be "1920" -- Milton Purdy ACCESS State of Arkansas "Steve Stad" wrote: 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") |
#4
|
|||
|
|||
#name? error
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") That should tell you if it is finding the field name. -- Milton Purdy ACCESS State of Arkansas "Steve Stad" wrote: 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" wrote: Are hours in units of time or text? If text your 1920's must be "1920" -- Milton Purdy ACCESS State of Arkansas "Steve Stad" wrote: 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") |
#5
|
|||
|
|||
#name? error
Golfinray,
I tried the formula you suggested... =IIf(Forms![qry_Emp_TotalHrsWorked subform]!SumOfEmp_Act_Prod_Hrs1920,"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" wrote: 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") That should tell you if it is finding the field name. -- Milton Purdy ACCESS State of Arkansas "Steve Stad" wrote: 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" wrote: Are hours in units of time or text? If text your 1920's must be "1920" -- Milton Purdy ACCESS State of Arkansas "Steve Stad" wrote: 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") |
#6
|
|||
|
|||
#name? error
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" wrote: Golfinray, I tried the formula you suggested... =IIf(Forms![qry_Emp_TotalHrsWorked subform]!SumOfEmp_Act_Prod_Hrs1920,"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" wrote: 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") That should tell you if it is finding the field name. -- Milton Purdy ACCESS State of Arkansas "Steve Stad" wrote: 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" wrote: Are hours in units of time or text? If text your 1920's must be "1920" -- Milton Purdy ACCESS State of Arkansas "Steve Stad" wrote: 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") |
Thread Tools | |
Display Modes | |
|
|