Kaup, Chester
Chester_Kaup at kindermorgan.com
Wed May 3 08:37:50 CDT 2006
I may have to do something like that because an export from access to a text file only got the first 474 characters of the memo field. Why that number I don't know. Certainly not a multiple of 2. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Long, Karen S. (CDC/NIOSH/NPPTL) (CTR) Sent: Wednesday, May 03, 2006 8:24 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Data from a SQL Server Table Too bad you can't use the Rich Text Format box from .net. Have you thought about using vb script to write the contents of the memo field to a .txt file, displaying that document, making changes, and then send it back to SQL? I have some code that will do that - I had a problem sort of like yours. Karen S. Long Programmer Analyst EG&G Technical Services, Inc. Pittsburgh, PA Phone: 412-386-6649 Email: cyx5 at cdc.gov -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Wednesday, May 03, 2006 8:43 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Data from a SQL Server Table The problem is I need to manipulate the data. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Tuesday, May 02, 2006 5:17 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Data from a SQL Server Table Then if you can see the whole value in a form, what's the problem? You don't let users see the linked table anyhow. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Tuesday, May 02, 2006 2:31 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Data from a SQL Server Table If I directly open the table I do not see the whole memo field. If I open it in a form I see the whole field. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Tuesday, May 02, 2006 2:59 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Data from a SQL Server Table Are you using a query to view the data? Are you trying to sort on the memo field? Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Tuesday, May 02, 2006 11:52 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Data from a SQL Server Table Access 2003 SQL Server 2000 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Tuesday, May 02, 2006 11:29 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Data from a SQL Server Table Which versions of Access and SQL Server? Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Tuesday, May 02, 2006 9:11 AM To: Access Developers discussion and problem solving Subject: [AccessD] Data from a SQL Server Table I am try to view the data from a SQL table that has one field that Access shows in design mode to be a memo field. Only part of the field displays. I tried exporting it to a text file and viewing it in Wordpad. I see more of the field but not all of it There is a distinct cutoff point (474 characters total on one line). Any suggestions on how to see all the contents of the field. I tried the LEN function on the field for one long record and got a count of 240. I know there are more characters than that. Does LEN not work on memo fields? Chester Kaup Engineering Technician Kinder Morgan CO2 Company, LLP Office (432) 688-3797 FAX (432) 688-3799 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com