|
| 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
December 2nd, 2006, 07:26 PM
posted to microsoft.public.access.queries
|
|||
|
|||
"#Name?" Error for only one cell of a record in a query? PLEASE HELP!
Yeah, I have a query that is populating in a subform. In the WHERE
clause I have one of the fields outside of the subfield. It shows everything fine except the particular table's (that I'm querying) key, which shows an "#Name?" value in it. Also, when I design view it and then view it again, it shows it properly. Is this a subform problem or a query problem? Thanks in advance, Ryan 
|
|
#2
December 2nd, 2006, 08:41 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"#Name?" Error for only one cell of a record in a query? PLEASE HELP!
On 2 Dec 2006 11:26:50 -0800, "Ryan Clair"
wrote: Yeah, I have a query that is populating in a subform. In the WHERE clause I have one of the fields outside of the subfield. It shows everything fine except the particular table's (that I'm querying) key, which shows an "#Name?" value in it. Also, when I design view it and then view it again, it shows it properly. Is this a subform problem or a query problem? One or the other, yes. We can't tell which unless you let us see the query. Please post the SQL view of the query here. Also explain what you mean by "one of the fields outside of the subfield" - Access doesn't have "subfields" and I have no clue what you're saying here! John W. Vinson[MVP]
|
|
#3
December 3rd, 2006, 07:31 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"#Name?" Error for only one cell of a record in a query? PLEASE HELP!
Heh. Oops. Yeah it was subFORMS that I meant to say. I figured out a
way around it but thank you for your time. Ryan John Vinson wrote: On 2 Dec 2006 11:26:50 -0800, "Ryan Clair" wrote: Yeah, I have a query that is populating in a subform. In the WHERE clause I have one of the fields outside of the subfield. It shows everything fine except the particular table's (that I'm querying) key, which shows an "#Name?" value in it. Also, when I design view it and then view it again, it shows it properly. Is this a subform problem or a query problem? One or the other, yes. We can't tell which unless you let us see the query. Please post the SQL view of the query here. Also explain what you mean by "one of the fields outside of the subfield" - Access doesn't have "subfields" and I have no clue what you're saying here! John W. Vinson[MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
