|
| 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
August 5th, 2009, 06:29 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
combing Last and First name
I trying to combine First and Last names into a form, however I just get the
#Name? I have typed =[Last_Name] & " " & [First_Name] in to the contral source however it just does not work? Please help i have been trying to do this for ages 
|
|
#2
August 5th, 2009, 06:35 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
combing Last and First name
Make sure you don't use either of the field names listed as the name of you
new control - call it Full_Name or something. Mich "rupe" wrote in message ... I trying to combine First and Last names into a form, however I just get the #Name? I have typed =[Last_Name] & " " & [First_Name] in to the contral source however it just does not work? Please help i have been trying to do this for ages
|
|
#3
August 5th, 2009, 07:04 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
combing Last and First name
When Access says "#Name" it means it can't find something spelled the way
you spelled it. Spelling counts. Regards Jeff Boyce Microsoft Office/Access MVP "rupe" wrote in message ... I trying to combine First and Last names into a form, however I just get the #Name? I have typed =[Last_Name] & " " & [First_Name] in to the contral source however it just does not work? Please help i have been trying to do this for ages
|
|
#4
August 5th, 2009, 10:04 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
combing Last and First name
On Wed, 5 Aug 2009 10:29:05 -0700, rupe
wrote: I trying to combine First and Last names into a form, however I just get the #Name? I have typed =[Last_Name] & " " & [First_Name] in to the contral source however it just does not work? Please help i have been trying to do this for ages What are the actual field names in your table? It would seem that they are something OTHER than [Last_Name] and [First_Name] - perhaps the actual field is called [Last Name], with a blank? Or might the fields in your table be Lookup fields? If so, they contain a number, not the actual name. -- John W. Vinson [MVP]
|
|
#5
August 5th, 2009, 11:52 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
combing Last and First name
As already stated, you likely have a spelling problem, but be aware the
control will present the name, but you will not be able to update it because it has to be one field to one control to be able to update it. -- Dave Hargis, Microsoft Access MVP "rupe" wrote: I trying to combine First and Last names into a form, however I just get the #Name? I have typed =[Last_Name] & " " & [First_Name] in to the contral source however it just does not work? Please help i have been trying to do this for ages
|
|
#6
August 6th, 2009, 01:26 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
combing Last and First name
Rupe,
Have you tried a new unbound textbox on your form with: =[Last_Name] & " " & [First_Name] Richard "rupe" wrote: I trying to combine First and Last names into a form, however I just get the #Name? I have typed =[Last_Name] & " " & [First_Name] in to the contral source however it just does not work? Please help i have been trying to do this for ages
|
|
#7
August 6th, 2009, 10:14 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
combing Last and First name
Yes and unfortunately the samething again
"Richard" wrote: Rupe, Have you tried a new unbound textbox on your form with: =[Last_Name] & " " & [First_Name] Richard "rupe" wrote: I trying to combine First and Last names into a form, however I just get the #Name? I have typed =[Last_Name] & " " & [First_Name] in to the contral source however it just does not work? Please help i have been trying to do this for ages
|
|
#8
August 6th, 2009, 10:17 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
combing Last and First name
I have checked the spelling over and over, but what do you mean by "it has to
be one field to one control" as i have only one Customer_ID to the linked Names fields? Thank you "Klatuu" wrote: As already stated, you likely have a spelling problem, but be aware the control will present the name, but you will not be able to update it because it has to be one field to one control to be able to update it. -- Dave Hargis, Microsoft Access MVP "rupe" wrote: I trying to combine First and Last names into a form, however I just get the #Name? I have typed =[Last_Name] & " " & [First_Name] in to the contral source however it just does not work? Please help i have been trying to do this for ages
|
|
#9
August 6th, 2009, 10:21 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
combing Last and First name
Are Last_Name and First_Name in the query that is the record source of the
form? Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "rupe" wrote in message ... Yes and unfortunately the samething again "Richard" wrote: Rupe, Have you tried a new unbound textbox on your form with: =[Last_Name] & " " & [First_Name] Richard "rupe" wrote: I trying to combine First and Last names into a form, however I just get the #Name? I have typed =[Last_Name] & " " & [First_Name] in to the contral source however it just does not work? Please help i have been trying to do this for ages
|
|
#10
August 6th, 2009, 10:24 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
combing Last and First name
The field names are [Last_Name] and [First_Name], no the last point i have
only text in the fields [Last_Name] and [First_Name] they are not numbers thank you for your help "John W. Vinson" wrote: On Wed, 5 Aug 2009 10:29:05 -0700, rupe wrote: I trying to combine First and Last names into a form, however I just get the #Name? I have typed =[Last_Name] & " " & [First_Name] in to the contral source however it just does not work? Please help i have been trying to do this for ages What are the actual field names in your table? It would seem that they are something OTHER than [Last_Name] and [First_Name] - perhaps the actual field is called [Last Name], with a blank? Or might the fields in your table be Lookup fields? If so, they contain a number, not the actual name. -- John W. Vinson [MVP]
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
