Appending from a text box

[DJ_DEF_CON_1]

I have a small database, which has a form with a text box that is unbound. A report is based off this form.

The user fills out this text box and then previews the report. The user, upon closing the report, is asked if they would like to save this information. If the user chooses to save this, the information is appended to a different database into a memo field.

The problem seems to be when there are too many characters in the text box, the append query craps out. Is there any way of having the append query work even if there are a lot of characters in the text box?

Thanks in advance for your assistance.

 

[jeremie_ingram]

Just a thought, but...

I would assign the text to a varible to aviod the loss. Im not sure if this would rectify your situation, but you could give it a try.

 

[DJ_DEF_CON_1]

Im relatively new to Access and I do not fully understand what you mean by "assign the text to a varible". If you do not mind, could you please describe that to me in more detail?

Thanks

 

[jeremie_ingram]

Ok, I have re-read your post and thought about it some more. Knowing your level here, i will break this down.
You have an established system which consists of a form and report and an additional table for the data IF it needs to be saved. What is missing from this equation would be another table to base the form and report off of.
call it tblTBox and have only one field in it. Call the field TBox and set it to MEMO which will allow for some 60k+ charecters to be entered. Now make sure that the table that holds the saved data has this field setting as well.
Next step would be to base the forms data source to tblTBox, and the text field should be bound to the one field TBox. The report will also need its datasource set to tblTBox and the area holding this information set to the field TBox.
Hope I havent lost you. All I am saying is to create an intermediate table that will 1) transfer the data from form to report, and 2) hold the data until the determination is made to save or not.

If you set it up like this, you just need to do some slight additional codeing to have the record saved if neccessary, or deleted (delete query) if neccessary.

I am cooking up an example for you, I will post it when I get it done.

 

[jeremie_ingram]

Take a look at this and tell me if I am on target or not. If its on track with your train of thought, take a look in the event procedures to see what code was used where.

 

[DJ_DEF_CON_1]

Unfortnatley I cannot open it. I am using Access 97. Are you a newer version that is not compatible?

 

[WayneRyan]

DJ,

Here's an A97 version.

Wayne

 

[DJ_DEF_CON_1]

THANKS!!!!

Thank you very much for all of your assistance.

 

[jeremie_ingram]

Sorry, i have a habbit of forgetting a lot of individuals here are still using 97. Thanks WayneRyan for the assist.

 

[Happy YN]

Identical problem?

Hi I have the identical problem. loading too many characters in the text box screws up the sql. I downloaded the examples in this thread but the identical error comes up so does anone have a way round this?
Thanks

 

[DJ_DEF_CON_1]

I put the changes into my database exactly as directed above and had no issues. Could you be more specific?

The directions that are the most critical are the following:

What is missing from this equation would be another table to base the form and report off of.
call it tblTBox and have only one field in it. Call the field TBox and set it to MEMO which will allow for some 60k+ charecters to be entered. Now make sure that the table that holds the saved data has this field setting as well.
Next step would be to base the forms data source to tblTBox, and the text field should be bound to the one field TBox. The report will also need its datasource set to tblTBox and the area holding this information set to the field TBox.
Hope I havent lost you. All I am saying is to create an intermediate table that will 1) transfer the data from form to report, and 2) hold the data until the determination is made to save or not.

If you set it up like this, you just need to do some slight additional codeing to have the record saved if neccessary, or deleted (delete query) if neccessary.

 

[Happy YN]

What difference does it make which table youare saving it to?
I got round the problem by using addnew method of dao
Thanks anyway!