insert memo feild into a memo field truncates at 255 characters -


B

Billp

Greetings I have a table that has a memo field to retain specific information
- text - which is the base of the combo box.

Via a combobox on a form this memo field is added to a forms field which is
also sized as a memo called "Project_Notes" - this part works.

At a certain time the user uploads this form and its feilds to a parent
table which also has a memo field to recieve the data from the other memo
field.

'we have created the new entry now we should update the notes
strOtherFields = ",Action_By,To_Do_date" _
& ",[Project_Notes],Status"

strsql = "INSERT INTO [tblsubProjectNotes] " _
& "(Works_Number" & strOtherFields & ") " _
& "SELECT '" & rst1!Works_Number & "' As
NewWorks_Number" _
& strOtherFields & " FROM tblProjectNotes_Input " _
& "WHERE Works_Number='" & rst1!Works_Number & "'" _
& "AND tblProjectNotes_Input!Sent_Input = False;"

the memo field is greater than 255 characters.
On INSERT the memo field is truncated to 255 characters.

Is there a way to get around this or resolve it ???????????
Thanx in advance.

Best Regards
 
Ad

Advertisements

K

Ken Snell

Assuming that the Works_Number field is the memo field? What is the SQL
statement for the rst1 recordset?
 
B

Billp

arrrrrrrrrr - thoughts here.
Project_Notes is the Memo field.
After some pain I cut the memo field up into blocks of around 255 characters
and insert step by step.
Sorry for the delay in posting a response just returned to home base after
being at the branch where I asked the question.

Ken Snell said:
Assuming that the Works_Number field is the memo field? What is the SQL
statement for the rst1 recordset?

--

Ken Snell
http://www.accessmvp.com/KDSnell/



Billp said:
Greetings I have a table that has a memo field to retain specific
information
- text - which is the base of the combo box.

Via a combobox on a form this memo field is added to a forms field which
is
also sized as a memo called "Project_Notes" - this part works.

At a certain time the user uploads this form and its feilds to a parent
table which also has a memo field to recieve the data from the other memo
field.

'we have created the new entry now we should update the notes
strOtherFields = ",Action_By,To_Do_date" _
& ",[Project_Notes],Status"

strsql = "INSERT INTO [tblsubProjectNotes] " _
& "(Works_Number" & strOtherFields & ") " _
& "SELECT '" & rst1!Works_Number & "' As
NewWorks_Number" _
& strOtherFields & " FROM tblProjectNotes_Input " _
& "WHERE Works_Number='" & rst1!Works_Number & "'" _
& "AND tblProjectNotes_Input!Sent_Input = False;"

the memo field is greater than 255 characters.
On INSERT the memo field is truncated to 255 characters.

Is there a way to get around this or resolve it ???????????
Thanx in advance.

Best Regards


.
 
K

Ken Snell

I don't even see a Project_Notes field in the code that you posted. Makes it
difficult to try to debug with you without having information... but glad
you found a workaround. If you'd give us much more details about your code
and query, we may be able to help you get back to where you wanted to be,
without the workaround.
--

Ken Snell
http://www.accessmvp.com/KDSnell/



Billp said:
arrrrrrrrrr - thoughts here.
Project_Notes is the Memo field.
After some pain I cut the memo field up into blocks of around 255
characters
and insert step by step.
Sorry for the delay in posting a response just returned to home base
after
being at the branch where I asked the question.

Ken Snell said:
Assuming that the Works_Number field is the memo field? What is the SQL
statement for the rst1 recordset?

--

Ken Snell
http://www.accessmvp.com/KDSnell/



Billp said:
Greetings I have a table that has a memo field to retain specific
information
- text - which is the base of the combo box.

Via a combobox on a form this memo field is added to a forms field
which
is
also sized as a memo called "Project_Notes" - this part works.

At a certain time the user uploads this form and its feilds to a parent
table which also has a memo field to recieve the data from the other
memo
field.

'we have created the new entry now we should update the notes
strOtherFields = ",Action_By,To_Do_date" _
& ",[Project_Notes],Status"

strsql = "INSERT INTO [tblsubProjectNotes] " _
& "(Works_Number" & strOtherFields & ") " _
& "SELECT '" & rst1!Works_Number & "' As
NewWorks_Number" _
& strOtherFields & " FROM tblProjectNotes_Input " _
& "WHERE Works_Number='" & rst1!Works_Number & "'" _
& "AND tblProjectNotes_Input!Sent_Input = False;"

the memo field is greater than 255 characters.
On INSERT the memo field is truncated to 255 characters.

Is there a way to get around this or resolve it ???????????
Thanx in advance.

Best Regards


.
 
Ad

Advertisements

K

Ken Snell

Mmmm, ok I see where you have Project_Notes field name in your string
variable. I assume that tblProjectNotes_Input is a table, not a query?

See Allen Browne's website for detailed information about truncation of memo
fields:
http://allenbrowne.com/ser-63.html

This URL shows two posts from Jamie Collins where he tested 7 different
scenarios for possible memo trunction:
http://groups.google.com/group/micr...4e2d1b65a60e7/489970072eafe7a3?hl=en&lnk=st&q

--

Ken Snell
http://www.accessmvp.com/KDSnell/



Ken Snell said:
I don't even see a Project_Notes field in the code that you posted. Makes
it difficult to try to debug with you without having information... but
glad you found a workaround. If you'd give us much more details about your
code and query, we may be able to help you get back to where you wanted to
be, without the workaround.
--

Ken Snell
http://www.accessmvp.com/KDSnell/



Billp said:
arrrrrrrrrr - thoughts here.
Project_Notes is the Memo field.
After some pain I cut the memo field up into blocks of around 255
characters
and insert step by step.
Sorry for the delay in posting a response just returned to home base
after
being at the branch where I asked the question.

Ken Snell said:
Assuming that the Works_Number field is the memo field? What is the SQL
statement for the rst1 recordset?

--

Ken Snell
http://www.accessmvp.com/KDSnell/



Greetings I have a table that has a memo field to retain specific
information
- text - which is the base of the combo box.

Via a combobox on a form this memo field is added to a forms field
which
is
also sized as a memo called "Project_Notes" - this part works.

At a certain time the user uploads this form and its feilds to a
parent
table which also has a memo field to recieve the data from the other
memo
field.

'we have created the new entry now we should update the notes
strOtherFields = ",Action_By,To_Do_date" _
& ",[Project_Notes],Status"

strsql = "INSERT INTO [tblsubProjectNotes] " _
& "(Works_Number" & strOtherFields & ") " _
& "SELECT '" & rst1!Works_Number & "' As
NewWorks_Number" _
& strOtherFields & " FROM tblProjectNotes_Input " _
& "WHERE Works_Number='" & rst1!Works_Number & "'"
_
& "AND tblProjectNotes_Input!Sent_Input = False;"

the memo field is greater than 255 characters.
On INSERT the memo field is truncated to 255 characters.

Is there a way to get around this or resolve it ???????????
Thanx in advance.

Best Regards


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top