append memo field via append query - Microsoft Access / VBA

Rose

I have an access 2000 database. In it I have a table OPEN Items which
has a field Issue that is setup as a MEMO field. I am trying to
append information from another table with the same setup, but it does
not bring in all of my memo field - it cuts off the data. I have
other queries setup to do the same thing from different tables and
they work fine. I cannot see anything different in my tables or
queries. Anyone have any ideas of what I might be doing wrong.

Nov 12 '05 #1

Subscribe Reply

3133

Allen Browne

The memo will be truncated if you use a source query that involves any
aggregation (e.g. a GROUP BY clause or DISTINCT predicate in a SQL
statement), or formatting (e.g. UCase(), or something in the Format property
of the memo field in the table or the Format property of the text box on a
form).

In a Totals query, you may be able to avoid the issue by using First(MyMemo)
instead of grouping by the memo field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Rose" <MA****@AOL.COM > wrote in message
news:e8******** *************** **@posting.goog le.com...

I have an access 2000 database. In it I have a table OPEN Items which
has a field Issue that is setup as a MEMO field. I am trying to
append information from another table with the same setup, but it does
not bring in all of my memo field - it cuts off the data. I have
other queries setup to do the same thing from different tables and
they work fine. I cannot see anything different in my tables or
queries. Anyone have any ideas of what I might be doing wrong.

Nov 12 '05 #2

Similar topics

10214

Memo field truncated in query/report?

by: GorDon | last post by:

Hi, I have a report based on a query. The query grabs a memo field from my main table, yet when I display the memo field in the report it truncates the memo field (the field needs to hold more than 255 characters). The table holds all the memo text, but the query seems to truncate the memo field to 255 chars? This seems like there should be a relatively easy fix, but I can't seem to find it.

Microsoft Access / VBA

8214

Truncated memo fields when using SELECT DISTINCT

by: skinnybloke | last post by:

Hi - I have a problem with a memo field being truncated to about 255 characters when running a Access 2002 query. This only seems to happen if I use SELECT DISTINCT. It works ok using SELECT by itself. does anyone know why this happens and how to stop it?

Microsoft Access / VBA

2339

Append Query/Memo Truncation

by: martinjeffreys | last post by:

Hello I'm using an append query from an Access front end to add data to a back-end SQL table. It all works OK - except a Memo field is being truncated to 765(ish) characters. Any thoughts gratefully received Martin J

Microsoft Access / VBA

3594

Query Truncates Memo Fields

by: jacoballen | last post by:

I have a query that combines the results of three related tables. The memo fields are truncated to 255 characters, but I need all the information in them. I'm aware that removing code such as DISTINCT and GROUPBY will fix this problem (as discussed in other threads in this group), but I need to limit the query results to unique values, which is what DISTINCT does for me. Any suggestions? Thanks, Jacob

Microsoft Access / VBA

360

append query

by: brino | last post by:

hi all ! i needed to append about 20 fields from a query into the 1 field of another table so that i can produce a report. i tried to do this in an append query but it would not work because i was appending all of the fields to the 1 field in the destination table. is there a way of doing this with the 1 query. at present i have to do over 20 querys , each one appending a single field only. im not sure if its possible to do this in one...

Microsoft Access / VBA

7926

Using CStr on a Memo field

by: midlothian | last post by:

Does using CStr on a memo field truncate it to 255 characters? Seems like this is happening with some data in my tables. Is there a way around this?

Microsoft Access / VBA

6805

Missing text from memo field

by: Teresa L | last post by:

I am using Access 2003. I have a memo field that I have put into a report. My problem is that the report will only show a specific amount of characters in the report. It does not display the entire field. I have checked the properties and they are set to memo so what is happening here? I think it is happening in more than one field but I have only been able to identify or replicate the problem in one field. Thanks

Microsoft Access / VBA

8848

Access 2007 Memo Field append only?

by: ARC | last post by:

This is taken from the "What's New in Access 2007" page. However, I've looked through all the properties of a text field memo box, and cannot find the append only option. Does anyone know how to use this feature? ------------------ "Memo fields are useful for storing large amounts of information. With Office Access 2007, you can set the Append Only property to retain a history of all changes to a Memo field. You can then view a history...

Microsoft Access / VBA

3171

Problem with append query - memo field

by: nujcharee | last post by:

Hi I have a series of queries, I have a number of temp tables which I use as templates for my data. I start with 1. Delete the data in a temp table 2. Use append query to fill the temp table with data Now, in the temp table, I have a memo field. I append information from a text column (Oracle DB) into the memofield in the temp table. For some reason, only the first 255 characters copied across as if it

Microsoft Access / VBA

9646

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10346

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10157

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10096

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7504

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6742

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5386

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5514

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3658

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP