New Recordset's Memo Field Data Lost On Update

Feb 29, 2008


i am adding a new row to an adodb.recordset, one of the fields being a Memo datatype.

all the other fields will write to the database fine, but with the memo, it will mysteriously disappear when i call rs.update

response.write(rs("my_memo_field")) 'give correct output
response.write(rs("my_memo_field")) 'gives nothing!

any one else had this happen and have a solution?


View Replies


Tables :: Long Text - Lost Functionality From Old Memo Type

Mar 28, 2014

I am a pretty novice user currently playing around with Access 2013 using Office 365.

I used to love the old style Memo field where people cut put in carriage returns to split up data. I am wondering if this function has been removed with this LONG TEXT FIELD or is there a way around it.

I like it because I tend to use it as a tracking field and like the newest "comments" at the top separated by a Carriage Return...

View 10 Replies View Related

Update Memo Field With Line Breaks

Jan 6, 2006

I have a memo field that contains several text strings separated by line breaks. I would like to write a query to add another text string to the end of the field. How do I embed a line feed in the SQL?

View 3 Replies View Related

Update Query Memo Field Question

Oct 7, 2007

I have a field [InternalComments] which is a memo field. Lots of data per customer

Can I make an update query to add data to the existing data without overriding the data currenty there?


View 14 Replies View Related

Lost Data In One Field After Performing A Search

Aug 8, 2015

I have a form frmMember, it has a search button that performs a complex search of fields. after performing my search my [BaseDues] field shows #Name? BaseDues is set by a CBO in the field above.

It works correctly except after the search...

Here is the Code for the Search Button:

Private Sub cmdSearchForm_Click()
On Error GoTo Err_cmdSearchForm_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmSearch"

[Code] .....

View 9 Replies View Related

Forms :: Log History Of Inputs - Using ComboBox To Update Memo Field

Jun 25, 2013

I am currently using the column history to log the history of inputs into a memo field.

But i now need to swap how my database runs and now require a combo box to have the same history function, as this is for a status updates and i require users to only input certain status's.

I no that I cant use the columnhistory command with a combo box.

When selecting a status from the combo box it automatically update the memo field (which will be hidden on the form) so the column history function works.

View 1 Replies View Related

Retrieve Data From Backend - Update Combo Box From Recordset

Dec 12, 2011

I have written code to retrieve data from a back-end, that is then bound to a form (late binding forms).

From the retrieved record set I want to update a combo box using 1 field from the data in the record set, only showing unique records in the list.

View 5 Replies View Related

Memo Field Data Extraction

Mar 1, 2007

Hi, i have a fox pro memo field that has bill of materials information in like so:EACH KIT COMPRISES

1 RBS24690 £0.82
1 RBS354 £0.95
2 RBS345 £0.75
1 S95MMEXT £3.90

£36.77 PER KIT

I need to take out the carriage returns but keep the items delimited in some way so they all apear on the one line. These are the child parts for kits so i need to keep them on one line as i import them or via a query so i can see the parent part they belong to. I can then extract them for upload into our system retaining the association with the parent part.


View 4 Replies View Related

Problem With Data Cutting Off In Memo Field

Nov 7, 2006

Iím not sure where to post this, but I know my problem arises from either my table or my textbox on my form. My problem is I have a text box on my form where my Managers input text (example below), and at times it cuts off their entries with weird characters. Iím not sure if they have exceeded the text box limit or the memo limit in the table but below is an exact example of what is showing up in the table after they submit their entry. Any help on this would be great.

Of the 1,800 unit decline, 684 were empties. The load decline of 1,116 can be summed up in the following lanes and beneficial owners. Chicago to Austell -200 loads, Georgia Pacific. This freight now moves over the road. Chicago to Harrisburg/Rutherford - 353 loads, SC Johnson business lost to JB Hunt back in September. Inbound/Outbound Jersey business lost to CSX last October, -226 loads. 2005 we moved right at 450 loads from Jacksonville/Austell to Bethlehem/Rutherford and Chicago for the yearly Wal-Maů?Ā

View 6 Replies View Related

Not Getting Entire Data From Memo Field On Query

Aug 24, 2005

Hi all,

I had table with following data


f1 f2 f3
1 10 aa......
1 11 aaa...
2 10 bb...
2 11 bb.......

f3 is memo field

I had to retrieve data by grouping records based on f1 value
so i gave groupby in totals section to f3 field also.

I am getting the values correctly, but memo field is truncating.
Its only displaying first half arround 236 charecters only.

If i query directly without performing any group by
then i am getting entire data for the memo field.

please any one give the solution.

waiting for your help.


View 1 Replies View Related

Memo Data Type Field On A Form

Jan 25, 2006

Hi all,

I have a question about an Access form that I am creating. I have a "Due Notes" field, which has Memo data type and I create a form "Estimates" using a text box with the control source is that "Due Notes" field to enter notes when needed.

Although I have the vertical scroll bar for that text box (due to other controls, I can not size the text box too big), does anybody know how to display that text box in form "Estimates" with the data of the last text within the size of the box without scrolling down so I can start typing for the next entry? Do I make sense to you?

Please help and let me know if you know HOW. Thanks so much in advance.

View 7 Replies View Related

How Can I Store 500KB Text Data Into A Memo Field?

Oct 15, 2006


The title says it. I want to store 500KB text data into a memo field. How can I do that?

Someone told me there is no limit on the size of a memo field, up to the maximum for a .mdb file of 2GB!!!

Your help would be greatly appeciated.

View 9 Replies View Related

Queries :: Extract Data From Memo Field And Put Into New Table

May 13, 2014

Is there a way I can take each entry in a memo field and put it into a text field in a separate table. The database is getting really big and the customer notes field for each record has lots of entries. The memo field looks like this:

8.4.14 Ordered 2 cartons
20.3.14 Ordered 2 cartons
4.3.14 Ordered 2 cartons
18.2.14 ordered 1 carton
30.1.14 ordered 3 cartons SCENTED wipes


I want to take each line and put put the date in a date field and the text in a text field in a separate table linked by CustID. Is there a way to do that?

View 7 Replies View Related

Forms :: Handling Large Amount Of Data In Memo Field

Jun 9, 2013

My DVD library database I have a memo field which has the description of the movies.

In some cases, like my tv show records, I have a lot of data because of the episodes and episode descriptions.

I'm currently displaying this data using a split form with the datasheet on the left

I must use a small font in the memo field in order to display all data.

I could use a larger font and simply scroll but I'm looking for an alternative.

I've even thought of creating a hyperlink filed and point to the movie on IMDB's web site. But when I click the link nothing happens even though I copied and pasted the link into the field.

View 8 Replies View Related

Importing Data From Excel To Memo Field In Access Is Truncated After 255 Characters

Nov 16, 2007

I haven't seen anyone run into this particular problem on this forum...

I'm importing data from an excel spreadsheet to an MS Access (2007) table. One of the fields in the table is a text memo field able to support more than 255 characters...

The issue is that any cell in Excel that is greater than 255 characters is truncated when imported to MS Access even though the field is a memo field. There isn't any documentation on Microsoft's website about this and I don't see any way to work around it other than manually copying the data from excel to MS Access.

Anyone have any input on this matter?

Thanks in advance!

View 3 Replies View Related

Tables :: Extract Data From Memo Field And Put Into Separate Fields Of New Table

Jun 15, 2014

I have a notes field in the customer table that is a memo field. An example of one customer's notes field data :

<div>20.3.14 Ordered 2 cartons</div>
<div>4.3.14 Ordered 2 cartons</div>
<div>18.2.14 ordered 1 carton</div>
<div>30.1.14 ordered 3 cartons SCENTED wipes</div>

[Code] ....

I want to extract the date to append to a date field in a "Calls" table and the comment into a text field in the "Calls" table. Is there a way I can do this via query or code?

View 2 Replies View Related

Update After Lost Focus

Sep 27, 2005

I have a form with a combo box for the user to select a specific date. I need to update the date field after the combo box loses focus instead of on the change of a record.

Can someone provide me the vb code that will update the field when the focus is lost?

Thanks for your help,


View 7 Replies View Related

Update Memo Value

Sep 19, 2006

Is there a way to populate the value of a memo field with the push of a button. What I am trying to do is have a few default items that can be automatically entered into a memo field. When I attempt to change the value of the memo field either thru the wizard, macro or by using a simple code like me.[memofield]="test" I get the error that you cannot assign a value to this object or by using setvalue through a macro i get the error "Object doesnt support this property or method"

Any help with this would be greatly appreciated



View 4 Replies View Related

Update Memo Query

Jun 9, 2006

i want to update a memo field with this query, but it won't work...says "Operation must use an updateable query". I've checked microsoft help and my connexion mode is ok, must be the syntax since its a memo field?

sqlupdate = "UPDATE sec_accueil SET contenu='" &varTxt& "'"


View 5 Replies View Related

Lost Data

Oct 25, 2006

I am not sure what is going on.

I have a DB set-up using Visual Basic. I have a status field. Datatype is memo field.

This problem does not occur everytime but when I input more then 2 lines of new information. Old information that was listed goes away and is replaced by ascii characters.

I would really appreciate some feedback on this problem.

Thanks in advance.

View 7 Replies View Related

Update Field To Todays Date When Data In Other Field Changes

Apr 27, 2008


i have 2 fields in a form - 'Balance' and 'Date'. Quite simply I need the date field to change automatically to todays date each time the data in the 'Balance' field is changed. Can anyone advise me on how to accomplish this.

Many thanks


View 2 Replies View Related

Update A Field Based On Data Entered In Another Field?

Jan 9, 2015

I am wanting to update data in one field which is being pulled in from another table based on an entry in another field in a form

Attached is the database. In the sales form I want to enter a customer ID which will then pull in the customer name from the customer table and put it in the Customer Field in the sales table.

I know I am duplicating the data by having customer name in both tables which is bad database design!

View 3 Replies View Related

Lost My All Data From A Table

Mar 22, 2007

I have a database with 400 table and my all data from a one table missing! Why? Please, help me!

View 4 Replies View Related

Form Data Is Lost

Feb 9, 2005

Hi ..
I have a lot of forms in my database. This database is already half way complete. I was not able to edit the data in the so I unlocked all the forms and allowed it to be edited, deleted and all those data related stuffs.
but I realised that making these changes makes all the data in the form lost.
All these forms are related but the data is only lost to those froms in which I make changes.
What should I do so that I dont lose the data and still I can work with the forms


View 2 Replies View Related

I'm Lost! How Can I Pull Data From Emails?

May 5, 2005

I'm working in Access 97 (though I can use Access2000) and Outlook2000 and am trying to write a process that will go into a specified folder in a user's outlook and pull in the data from the emails there. The data will be in a standard csv format - but my biggest problem is trying to figure out how to systematically go into the folder, import the data from the email, and then move to the next email in the folder...

Any help would be much appreciated!

View 2 Replies View Related

Lost Table Data While Creating Query

Jul 30, 2006

I did a query based on a table. I deleted some records from my new query and when I went back to the original table the same data had been deleted from there too. Help.

View 5 Replies View Related

Copyrights 2005-15, All rights reserved