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?
Hi,
I created a query, and it seems to work fine and I am pulling data from it to populate three reports. But, there is a weird thing that happens. When I open the query in Datasheet view then scroll along to the right all of the data suddenly becomes #Name?. What is this and is it something I can repair? Thanks. |
#2
|
|||
|
|||
#Name?
Does that field use a function such as CDate, CStr, etc? If so the data hits
something that causes a problem for the function such as a null value. Post the SQL and which field is causing problems. Another possibility is that you have a corrupt database. Is the field in question a Memo field by chance? -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Novice2000" wrote: Hi, I created a query, and it seems to work fine and I am pulling data from it to populate three reports. But, there is a weird thing that happens. When I open the query in Datasheet view then scroll along to the right all of the data suddenly becomes #Name?. What is this and is it something I can repair? Thanks. |
#3
|
|||
|
|||
#Name?
It's every field in the entire query that changes. It could be corrrupt I
guess, but it still works and I tried to build a new query and it still does the same thing. "Jerry Whittle" wrote: Does that field use a function such as CDate, CStr, etc? If so the data hits something that causes a problem for the function such as a null value. Post the SQL and which field is causing problems. Another possibility is that you have a corrupt database. Is the field in question a Memo field by chance? -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Novice2000" wrote: Hi, I created a query, and it seems to work fine and I am pulling data from it to populate three reports. But, there is a weird thing that happens. When I open the query in Datasheet view then scroll along to the right all of the data suddenly becomes #Name?. What is this and is it something I can repair? Thanks. |
#4
|
|||
|
|||
#Name?
Its every field that changes. I guess it could be corrupt, but it still works
fine. I tried to build a new one from scratch, but it does the exact same thing at the first one. It is connected through the Sequel Server to another database. "Jerry Whittle" wrote: Does that field use a function such as CDate, CStr, etc? If so the data hits something that causes a problem for the function such as a null value. Post the SQL and which field is causing problems. Another possibility is that you have a corrupt database. Is the field in question a Memo field by chance? -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Novice2000" wrote: Hi, I created a query, and it seems to work fine and I am pulling data from it to populate three reports. But, there is a weird thing that happens. When I open the query in Datasheet view then scroll along to the right all of the data suddenly becomes #Name?. What is this and is it something I can repair? Thanks. |
Thread Tools | |
Display Modes | |
|
|