Using Form to Write to a Table

[Louis]

I'm using a form to append records to a Request table. On the form is
a Text Box for users to enter the description of the request and it
can be quite lengthy. When I use an append query to capture the
content of the form (each element mapped to a specific field in the
Request table) the record will be appended perfectly as long as the
text box content (request description) is short. This text box is
mapped to a memo field in the table but the limiting factor is the
query. It is only limited to 255 characters (actually half that). Is
there a way to append a record to a table through another means, a way
to increase the query's memory size to fill the memo field or is there
a feature that I should be aware of??? Thanks in advance!

[Larry Linson]

Why don't you use a form bound (in its RecordSource) either to the Table or
to a Query including the table? Truly, that is a lot easier than using an
unbound form as you seem to be doing.

Larry Linson
Microsoft Access MVP

"Louis" <lo*******@lycos.com> wrote in message
news:13*************************@posting.google.co m...

I'm using a form to append records to a Request table. On the form is
a Text Box for users to enter the description of the request and it
can be quite lengthy. When I use an append query to capture the
content of the form (each element mapped to a specific field in the
Request table) the record will be appended perfectly as long as the
text box content (request description) is short. This text box is
mapped to a memo field in the table but the limiting factor is the
query. It is only limited to 255 characters (actually half that). Is
there a way to append a record to a table through another means, a way
to increase the query's memory size to fill the memo field or is there
a feature that I should be aware of??? Thanks in advance!

[Peter Russell]

You can't directly execute a query which has a reference to a field which
is more than 255 chars.

What you must do is create a string as a query statement which already
resolves the form references. Something like (hope I get the quotes
right!)

strSQL = "INSERT INTO Mytbl( myID, mymemofield ) " & _
"VALUES (""" & Me!MyID & """, """ & Me!mymemofield & """);"

CurrentDb.Execute strSQL, dbFailOnError

Regards

Peter Russsell

Louis previously wrote:

I'm using a form to append records to a Request table. On the form is
a Text Box for users to enter the description of the request and it
can be quite lengthy. When I use an append query to capture the
content of the form (each element mapped to a specific field in the
Request table) the record will be appended perfectly as long as the
text box content (request description) is short. This text box is
mapped to a memo field in the table but the limiting factor is the
query. It is only limited to 255 characters (actually half that). Is
there a way to append a record to a table through another means, a way
to increase the query's memory size to fill the memo field or is there
a feature that I should be aware of??? Thanks in advance!

[Pieter Linden]

Any reason for not using bound forms?

[Louis]

Thank you all for your responses. I'm using unbounded form due to my
custom auto number routine. I have a query where, depending on the
type of requst submitted, the request ID generates a prefix (i.e.
AP1001, RD1001 and so on) so that I can classifiy the record with the
prefix in addition to the request type.

That's besides the point. Anyways, the solution that I came up with
was to create a temporary table that my form can bound to then use an
append query to copy from the query generated Request ID and the temp
table to the Request table. It works wonderfully and I actually got
the idea from another questions that someone wrote on this forum which
wasn't related to my question but the solution fit perfectly!

pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...

Any reason for not using bound forms?