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 |
#11
|
|||
|
|||
Do these values appear in separate fields in each record in your incoming
data stream? Name Address City, State, Zip DOB, SSN If yes, then you can use a query to concatenate the fields into a single string and output the result (example shown here is for three fields, with a blank space separting the value from each field): SELECT [Field1] & " " & [Field2] & " " [Field3] AS OutputField FROM TableName; -- Ken Snell MS ACCESS MVP "Blaze" wrote in message ... Here's what I am doing source to destination: 1. Infopath used to fill out repeating tables, with merge setup. 1b. Repeating Table has 8 fields as described previously. 2. Infopath submit used to post the data to sharepoint services with merge on the repeating tables. 3. I use Access to look at the sharepoint site. The data comes in with the boxes already there. I think it has something to do with the merge field. 4. I use the query to plug the report into something usable as infopath is near worthless except to enter data with integrity. Now, I have use the build command to do the following: as Fredg provided: Replace([FieldName],chr(13),chr(13) & chr(10)) This works to do what I needed. Now is there a way to combine: Name Address City, State, Zip DOB, SSN One entry per incoming data stream? If not, I can just put two text boxes with the data source laid out and it would work, just wouldn't be as "neat" Thanks for your input on this issue, you've been a real help! Blaze "Ken Snell [MVP]" wrote: This query does not show any concatenation being done in the query, so I must assume that the ComplaintNarrativeOtherNames field in the Complaint and Witness Forms table/query contains the concatenated names? Need to know where the concatenation of the Chr(13) (carriage return) character is being done, or if the Chr(13) character is already in the data before the query selects the records. -- Ken Snell MS ACCESS MVP "Blaze" wrote in message ... Nevermind, found it... This is a simplified version of what I am doing. Select [Complaint and Witness Forms].ID, [Complaint and Witness Forms.ComplaintNarrativeOtherNames From [Complaint and Witness Forms] Where ((([Complaint and Witness Forms].ID)=[ID]))); "Ken Snell [MVP]" wrote: Post the query's SQL statement. It appears that you are using only half of what you need to start a new line. In ACCESS, you use the combination of Chr(13) & Chr(10) for a new line (carriage return and line feed, respectively). -- Ken Snell MS ACCESS MVP "Blaze" wrote in message ... I have a query that seperates the fields by "square boxes". I am pretty sure that these are from an unknown character, but how can I find out what it is? Here is an example of what I want: Michael S Parrill Jessica L Davis Cody A Phipps David W Henderson Jr When I copied and pasted it from my query it shows up correctly, as you can see above, the query looks something like this: Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr The [] is the "square box symbol". When I copy that symbol into here, it is treated as a carriage return. Help, as I'm going nuts on this! Blaze |
#12
|
|||
|
|||
They are in different fields. I'm using the chr(10) & chr(13) command to
seperate the CR's. Can I still do this? Thanks! Blaze "Ken Snell [MVP]" wrote: Do these values appear in separate fields in each record in your incoming data stream? Name Address City, State, Zip DOB, SSN If yes, then you can use a query to concatenate the fields into a single string and output the result (example shown here is for three fields, with a blank space separting the value from each field): SELECT [Field1] & " " & [Field2] & " " [Field3] AS OutputField FROM TableName; -- Ken Snell MS ACCESS MVP "Blaze" wrote in message ... Here's what I am doing source to destination: 1. Infopath used to fill out repeating tables, with merge setup. 1b. Repeating Table has 8 fields as described previously. 2. Infopath submit used to post the data to sharepoint services with merge on the repeating tables. 3. I use Access to look at the sharepoint site. The data comes in with the boxes already there. I think it has something to do with the merge field. 4. I use the query to plug the report into something usable as infopath is near worthless except to enter data with integrity. Now, I have use the build command to do the following: as Fredg provided: Replace([FieldName],chr(13),chr(13) & chr(10)) This works to do what I needed. Now is there a way to combine: Name Address City, State, Zip DOB, SSN One entry per incoming data stream? If not, I can just put two text boxes with the data source laid out and it would work, just wouldn't be as "neat" Thanks for your input on this issue, you've been a real help! Blaze "Ken Snell [MVP]" wrote: This query does not show any concatenation being done in the query, so I must assume that the ComplaintNarrativeOtherNames field in the Complaint and Witness Forms table/query contains the concatenated names? Need to know where the concatenation of the Chr(13) (carriage return) character is being done, or if the Chr(13) character is already in the data before the query selects the records. -- Ken Snell MS ACCESS MVP "Blaze" wrote in message ... Nevermind, found it... This is a simplified version of what I am doing. Select [Complaint and Witness Forms].ID, [Complaint and Witness Forms.ComplaintNarrativeOtherNames From [Complaint and Witness Forms] Where ((([Complaint and Witness Forms].ID)=[ID]))); "Ken Snell [MVP]" wrote: Post the query's SQL statement. It appears that you are using only half of what you need to start a new line. In ACCESS, you use the combination of Chr(13) & Chr(10) for a new line (carriage return and line feed, respectively). -- Ken Snell MS ACCESS MVP "Blaze" wrote in message ... I have a query that seperates the fields by "square boxes". I am pretty sure that these are from an unknown character, but how can I find out what it is? Here is an example of what I want: Michael S Parrill Jessica L Davis Cody A Phipps David W Henderson Jr When I copied and pasted it from my query it shows up correctly, as you can see above, the query looks something like this: Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr The [] is the "square box symbol". When I copy that symbol into here, it is treated as a carriage return. Help, as I'm going nuts on this! Blaze |
#13
|
|||
|
|||
Works with the chr(10).
Thank you for the great advise, I was somewhat lost! Blaze "fredg" wrote: On Fri, 5 Aug 2005 13:29:02 -0700, Blaze wrote: I tried the replace method to see if that helped and I still have the "square boxes". Should I see if it's just the opposite or is there a way to see the raw ascii code from the data stream? Blaze "fredg" wrote: On Fri, 5 Aug 2005 12:29:03 -0700, Blaze wrote: I have a query that seperates the fields by "square boxes". I am pretty sure that these are from an unknown character, but how can I find out what it is? Here is an example of what I want: Michael S Parrill Jessica L Davis Cody A Phipps David W Henderson Jr When I copied and pasted it from my query it shows up correctly, as you can see above, the query looks something like this: Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr The [] is the "square box symbol". When I copy that symbol into here, it is treated as a carriage return. Help, as I'm going nuts on this! Blaze It probably is a carriage return, chr(13). Because Access requires both the carriage return as well as a line space to go to the next line ( chr(13) & chr(10) ), it shows the return as a square. What do you want to do with it? Make it into a real Access new line? Update YourTable Set YourTable.FieldName = Replace([FieldName],chr(13),chr(13) & chr(10)) Replace it with a space? Update YourTable Set YourTable.FieldName = Replace([FieldName],chr(13)," ") -- Fred Please only reply to this newsgroup. I do not reply to personal email. You can check the Ascii of that character, or first try Replace([FieldName],chr(10),"What ever you want here ") -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#14
|
|||
|
|||
If you can post details about the table's structure, and the fields' actual
contents (examples would be good), I'm sure we can give you a more specific query to do what you seek. Otherwise, the generic query I suggested earlier is as much as I can provide at this moment. -- Ken Snell MS ACCESS MVP "Blaze" wrote in message ... They are in different fields. I'm using the chr(10) & chr(13) command to seperate the CR's. Can I still do this? Thanks! Blaze "Ken Snell [MVP]" wrote: Do these values appear in separate fields in each record in your incoming data stream? Name Address City, State, Zip DOB, SSN If yes, then you can use a query to concatenate the fields into a single string and output the result (example shown here is for three fields, with a blank space separting the value from each field): SELECT [Field1] & " " & [Field2] & " " [Field3] AS OutputField FROM TableName; -- Ken Snell MS ACCESS MVP "Blaze" wrote in message ... Here's what I am doing source to destination: 1. Infopath used to fill out repeating tables, with merge setup. 1b. Repeating Table has 8 fields as described previously. 2. Infopath submit used to post the data to sharepoint services with merge on the repeating tables. 3. I use Access to look at the sharepoint site. The data comes in with the boxes already there. I think it has something to do with the merge field. 4. I use the query to plug the report into something usable as infopath is near worthless except to enter data with integrity. Now, I have use the build command to do the following: as Fredg provided: Replace([FieldName],chr(13),chr(13) & chr(10)) This works to do what I needed. Now is there a way to combine: Name Address City, State, Zip DOB, SSN One entry per incoming data stream? If not, I can just put two text boxes with the data source laid out and it would work, just wouldn't be as "neat" Thanks for your input on this issue, you've been a real help! Blaze "Ken Snell [MVP]" wrote: This query does not show any concatenation being done in the query, so I must assume that the ComplaintNarrativeOtherNames field in the Complaint and Witness Forms table/query contains the concatenated names? Need to know where the concatenation of the Chr(13) (carriage return) character is being done, or if the Chr(13) character is already in the data before the query selects the records. -- Ken Snell MS ACCESS MVP "Blaze" wrote in message ... Nevermind, found it... This is a simplified version of what I am doing. Select [Complaint and Witness Forms].ID, [Complaint and Witness Forms.ComplaintNarrativeOtherNames From [Complaint and Witness Forms] Where ((([Complaint and Witness Forms].ID)=[ID]))); "Ken Snell [MVP]" wrote: Post the query's SQL statement. It appears that you are using only half of what you need to start a new line. In ACCESS, you use the combination of Chr(13) & Chr(10) for a new line (carriage return and line feed, respectively). -- Ken Snell MS ACCESS MVP "Blaze" wrote in message ... I have a query that seperates the fields by "square boxes". I am pretty sure that these are from an unknown character, but how can I find out what it is? Here is an example of what I want: Michael S Parrill Jessica L Davis Cody A Phipps David W Henderson Jr When I copied and pasted it from my query it shows up correctly, as you can see above, the query looks something like this: Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr The [] is the "square box symbol". When I copy that symbol into here, it is treated as a carriage return. Help, as I'm going nuts on this! Blaze |
#15
|
|||
|
|||
The only changes are the the Chr(10) came first, so the replace looked like
this: Replace([FieldName],chr(10),chr(13) & chr(10)) "Ken Snell [MVP]" wrote: If you can post details about the table's structure, and the fields' actual contents (examples would be good), I'm sure we can give you a more specific query to do what you seek. Otherwise, the generic query I suggested earlier is as much as I can provide at this moment. -- Ken Snell MS ACCESS MVP "Blaze" wrote in message ... They are in different fields. I'm using the chr(10) & chr(13) command to seperate the CR's. Can I still do this? Thanks! Blaze "Ken Snell [MVP]" wrote: Do these values appear in separate fields in each record in your incoming data stream? Name Address City, State, Zip DOB, SSN If yes, then you can use a query to concatenate the fields into a single string and output the result (example shown here is for three fields, with a blank space separting the value from each field): SELECT [Field1] & " " & [Field2] & " " [Field3] AS OutputField FROM TableName; -- Ken Snell MS ACCESS MVP "Blaze" wrote in message ... Here's what I am doing source to destination: 1. Infopath used to fill out repeating tables, with merge setup. 1b. Repeating Table has 8 fields as described previously. 2. Infopath submit used to post the data to sharepoint services with merge on the repeating tables. 3. I use Access to look at the sharepoint site. The data comes in with the boxes already there. I think it has something to do with the merge field. 4. I use the query to plug the report into something usable as infopath is near worthless except to enter data with integrity. Now, I have use the build command to do the following: as Fredg provided: Replace([FieldName],chr(13),chr(13) & chr(10)) This works to do what I needed. Now is there a way to combine: Name Address City, State, Zip DOB, SSN One entry per incoming data stream? If not, I can just put two text boxes with the data source laid out and it would work, just wouldn't be as "neat" Thanks for your input on this issue, you've been a real help! Blaze "Ken Snell [MVP]" wrote: This query does not show any concatenation being done in the query, so I must assume that the ComplaintNarrativeOtherNames field in the Complaint and Witness Forms table/query contains the concatenated names? Need to know where the concatenation of the Chr(13) (carriage return) character is being done, or if the Chr(13) character is already in the data before the query selects the records. -- Ken Snell MS ACCESS MVP "Blaze" wrote in message ... Nevermind, found it... This is a simplified version of what I am doing. Select [Complaint and Witness Forms].ID, [Complaint and Witness Forms.ComplaintNarrativeOtherNames From [Complaint and Witness Forms] Where ((([Complaint and Witness Forms].ID)=[ID]))); "Ken Snell [MVP]" wrote: Post the query's SQL statement. It appears that you are using only half of what you need to start a new line. In ACCESS, you use the combination of Chr(13) & Chr(10) for a new line (carriage return and line feed, respectively). -- Ken Snell MS ACCESS MVP "Blaze" wrote in message ... I have a query that seperates the fields by "square boxes". I am pretty sure that these are from an unknown character, but how can I find out what it is? Here is an example of what I want: Michael S Parrill Jessica L Davis Cody A Phipps David W Henderson Jr When I copied and pasted it from my query it shows up correctly, as you can see above, the query looks something like this: Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr The [] is the "square box symbol". When I copy that symbol into here, it is treated as a carriage return. Help, as I'm going nuts on this! Blaze |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Listboxes, text boxes and combo boxes | diddydi | Using Forms | 2 | September 12th, 2005 01:16 PM |
ComboBox populates text boxes, how to edit text now? | DrewTheFather | Using Forms | 2 | August 9th, 2005 08:37 PM |
Word has changed data to square boxes..Why? | Wanda | General Discussion | 2 | June 26th, 2005 07:09 AM |
Eliminating square boxes in a text field | Haji | Setting Up & Running Reports | 10 | March 27th, 2005 04:27 AM |
More alternatives to text boxes. | David Young | Page Layout | 2 | April 26th, 2004 04:47 PM |