[AccessD] Data from a SQL Server Table

Long, Karen S. (CDC/NIOSH/NPPTL) (CTR) cyx5 at cdc.gov
Wed May 3 08:24:06 CDT 2006


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




More information about the AccessD mailing list