From zlatko.matic1@sb.t-com.hr Tue Oct  4 10:42:23 2005
X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id A8A0DD9ED2;
	Tue,  4 Oct 2005 07:42:23 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 64486-04; Tue,  4 Oct 2005 10:42:18 +0000 (GMT)
Received: from ls405.htnet.hr (ls405.htnet.hr [195.29.150.97])
	by svr1.postgresql.org (Postfix) with ESMTP id 34EBAD9B47;
	Tue,  4 Oct 2005 07:42:16 -0300 (ADT)
Received: from ls422.t-com.hr (ls422.t-com.hr [195.29.150.237])
	by ls405.htnet.hr (0.0.0/8.12.10) with ESMTP id j94AgIWl021850;
	Tue, 4 Oct 2005 12:42:18 +0200
Received: from ls422.t-com.hr (localhost.localdomain [127.0.0.1])
	by ls422.t-com.hr (Qmlai) with ESMTP id 4EF1D988045;
	Tue,  4 Oct 2005 12:42:18 +0200 (CEST)
X-Envelope-Sender: zlatko.matic1@sb.t-com.hr
X-Envelope-Sender: zlatko.matic1@sb.t-com.hr
X-Envelope-Sender: zlatko.matic1@sb.t-com.hr
X-Envelope-Sender: zlatko.matic1@sb.t-com.hr
Received: from ls422.t-com.hr (localhost.localdomain [127.0.0.1])
	by ls422.t-com.hr (Qmlai) with ESMTP id 2DF97988042;
	Tue,  4 Oct 2005 12:42:18 +0200 (CEST)
Received: from zlatkovyfkpgz6 (ao9-m271.net.t-com.hr [195.29.41.31])
	by ls422.t-com.hr (Qmlai) with SMTP id AA42D8B804A;
	Tue,  4 Oct 2005 12:42:16 +0200 (CEST)
Message-ID: <000101c5c8d0$4a2fb340$1f291dc3@zlatkovyfkpgz6>
From: =?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr>
To: <pgsql-odbc@postgresql.org>, <pg-interfaces@postgresql.org>,
	<pgsql-interfaces@postgresql.org>, <pgsql-general@postgresql.org>
Subject: Unbound text box, Text > 255 characters, MSAccess/PostgreSQL
Date: Mon, 3 Oct 2005 01:14:57 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0006_01C5C7B7.DEA512F0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.296 required=5 tests=[AWL=-0.093,
	DATE_IN_PAST_24_48=0.302, HTML_40_50=0.086, HTML_MESSAGE=0.001]
X-Spam-Level: 
X-Archive-Number: 200510/95
X-Sequence-Number: 84324

This is a multi-part message in MIME format.

------=_NextPart_000_0006_01C5C7B7.DEA512F0
Content-Type: text/plain;
	charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

Hello.
I have the following problem with MS Access/PostgreSQL combination:
There is a form in Access that has an unbound text box, used for =
entering a commentary of a batch of records.
There is a DAO Append Query that has a parameter that is passed from the =
text box using parameter of DAO QueryDef object.=20
I adjusted B7 parameter (Text as LongVarchar) in connection string (ODBC =
driver) to 1, so that Access links PostgreSQL Text fields as Memo fields =
in Access. The intention was to be able to enter unlimited length =
commentary into the field.
But, although I can enter unlimited text by using bound text box in some =
other forms, in this particular form I can't use bound control, so I =
need to pass text from  UNBOUND control to the linked table by using DAO =
or ADO code. It seems that DAO query can't accept Memo as parameter, but =
only text. If my text exceeds length of 255, I have an VBA error 3271. =
If text in unbound text box is shorter that 255 everything is OK.

So, is there any way to pass text of length >255 from unbound text box =
to Memo field of linked PostgreSQL table, by using DAO or ADO ?

Thanks in advance,

Zlatko
------=_NextPart_000_0006_01C5C7B7.DEA512F0
Content-Type: text/html;
	charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-2">
<META content=3D"MSHTML 6.00.2900.2722" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have the following problem with MS=20
Access/PostgreSQL combination:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>There is a form in Access that&nbsp;has =
an unbound=20
text box, used for entering a commentary of a batch of =
records.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>There is a DAO Append Query that has a =
parameter=20
that is passed from the text box using parameter of DAO QueryDef object. =

</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I adjusted B7 parameter (Text as =
LongVarchar) in=20
connection string (ODBC driver)&nbsp;to 1, so that Access links =
PostgreSQL Text=20
fields as Memo fields in Access. The intention was to be able to enter =
unlimited=20
length commentary into the field.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>But, although I can enter unlimited =
text by using=20
bound text box in some other forms, in this particular form I can't use =
bound=20
control, so I need to pass text&nbsp;from&nbsp; UNBOUND&nbsp;control to =
the=20
linked table&nbsp;by using DAO or ADO code. It seems that DAO query =
can't accept=20
Memo as parameter, but only text. If my text exceeds length of 255, I =
have an=20
VBA error 3271. If text in unbound text box is shorter that 255 =
everything is=20
OK.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>So, is there any way to pass text of =
length &gt;255=20
from unbound text box to Memo field&nbsp;of linked PostgreSQL table, by =
using=20
DAO or ADO ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Zlatko</FONT></DIV></BODY></HTML>

------=_NextPart_000_0006_01C5C7B7.DEA512F0--




From greg.campbell@us.michelin.com Tue Oct  4 13:42:20 2005
X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 0F4A2DA0BC;
	Tue,  4 Oct 2005 10:42:20 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 27470-07; Tue,  4 Oct 2005 13:42:10 +0000 (GMT)
Received: from gk-us2.us.michelin.com (gk-us2.michelin.com [156.65.14.19])
	by svr1.postgresql.org (Postfix) with ESMTP id DDDD1DA0C4;
	Tue,  4 Oct 2005 10:34:22 -0300 (ADT)
Received: from oncpfxp3-out.onc.michelin.com (unverified [10.21.4.30]) by
	gk-us2.us.michelin.com (Clearswift SMTPRS 5.1.4) with ESMTP id
	<T73c763e46a0a16198713a0@gk-us2.us.michelin.com>;
	Tue, 4 Oct 2005 09:34:11 -0400
Received: from ONCMH1.onc.michelin.com (ONCMH1.onc.michelin.com
	[156.65.124.40])
	by oncpfxp3-out.onc.michelin.com (Postfix) with ESMTP id C08E91A4B6;
	Tue,  4 Oct 2005 09:34:22 -0400 (EDT)
Received: from oncmtap1.onc.michelin.com by oncmh1.onc.michelin.com with
 ESMTP;
	Tue, 4 Oct 2005 09:34:22 -0400
Received: from oncems01.onc.michelin.com ([156.65.125.150]) by
	oncmtap1.onc.michelin.com (Netscape Messaging Server 4.15) with
	ESMTP id INU8D400.P2X; Tue, 4 Oct 2005 09:34:16 -0400
Received: from [10.43.12.183] (unverified) by oncems01.onc.michelin.com
	(Content Technologies SMTPRS 4.2.5) with ESMTP id
	<T73c763f7079c417d964e4@oncems01.onc.michelin.com>;
	Tue, 4 Oct 2005 09:34:16 -0400
Message-Id: <434284D6.3040708@us.michelin.com>
Date: Tue, 04 Oct 2005 09:34:14 -0400
From: "Greg Campbell" <greg.campbell@us.michelin.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.7.7) Gecko/20050414
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: =?ISO-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr>
Cc: pgsql-odbc@postgresql.org, pg-interfaces@postgresql.org,
	pgsql-interfaces@postgresql.org, pgsql-general@postgresql.org
Subject: Re: [ODBC] Unbound text box, Text > 255 characters,
	MSAccess/PostgreSQL
References: <000101c5c8d0$4a2fb340$1f291dc3@zlatkovyfkpgz6>
In-Reply-To: <000101c5c8d0$4a2fb340$1f291dc3@zlatkovyfkpgz6>
Content-Type: multipart/mixed; boundary="------------010601090306000506050402"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.009 required=5 tests=[AWL=0.009]
X-Spam-Level: 
X-Archive-Number: 200510/99
X-Sequence-Number: 84328

This is a multi-part message in MIME format.
--------------010601090306000506050402
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 8bit

What version of Access?
Confirm that Access is interpreting the target field as MEMO, (either look at the linked table in design 
mode, or use Tools->Analyze->Documenter).
For the query, determine the "type" of the parameter - Query menu->Parameters. Be sure you are using type 
MEMO.

By the way, 3271 is a Jet error -- Invalid property value.

Good luck.



Zlatko Matiæ wrote:

> Hello.
> I have the following problem with MS Access/PostgreSQL combination:
> There is a form in Access that has an unbound text box, used for entering a commentary of a batch of records.
> There is a DAO Append Query that has a parameter that is passed from the text box using parameter of DAO QueryDef object. 
> I adjusted B7 parameter (Text as LongVarchar) in connection string (ODBC driver) to 1, so that Access links PostgreSQL Text fields as Memo fields in Access. The intention was to be able to enter unlimited length commentary into the field.
> But, although I can enter unlimited text by using bound text box in some other forms, in this particular form I can't use bound control, so I need to pass text from  UNBOUND control to the linked table by using DAO or ADO code. It seems that DAO query can't accept Memo as parameter, but only text. If my text exceeds length of 255, I have an VBA error 3271. If text in unbound text box is shorter that 255 everything is OK.
> 
> So, is there any way to pass text of length >255 from unbound text box to Memo field of linked PostgreSQL table, by using DAO or ADO ?
> 
> Thanks in advance,
> 
> Zlatko

--------------010601090306000506050402
Content-Type: text/x-vcard; charset=utf-8;
 name="greg.campbell.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="greg.campbell.vcf"

begin:vcard
fn:Greg Campbell
n:Campbell;Greg
org:Michelin North America - US5 Lexington;ENG-ASE
email;internet:greg.campbell@us.michelin.com
title:ASE Systems Engineer
tel;work:803-951-5561/x75561
x-mozilla-html:FALSE
version:2.1
end:vcard


--------------010601090306000506050402--



From zlatko.matic1@sb.t-com.hr Thu Oct  6 14:45:11 2005
X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 37F23D952A;
	Thu,  6 Oct 2005 11:45:11 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 48303-07; Thu,  6 Oct 2005 14:45:05 +0000 (GMT)
Received: from ls405.htnet.hr (ls405.htnet.hr [195.29.150.97])
	by svr1.postgresql.org (Postfix) with ESMTP id 2A1F2DA3CB;
	Thu,  6 Oct 2005 11:45:05 -0300 (ADT)
Received: from ls401.t-com.hr (ls401.t-com.hr [195.29.150.236])
	by ls405.htnet.hr (0.0.0/8.12.10) with ESMTP id j96Ej7Wj009423;
	Thu, 6 Oct 2005 16:45:07 +0200
Received: from ls401.t-com.hr (localhost.localdomain [127.0.0.1])
	by ls401.t-com.hr (Qmlai) with ESMTP id 713FB70003;
	Thu,  6 Oct 2005 16:45:07 +0200 (CEST)
X-Envelope-Sender: zlatko.matic1@sb.t-com.hr
X-Envelope-Sender: zlatko.matic1@sb.t-com.hr
X-Envelope-Sender: zlatko.matic1@sb.t-com.hr
X-Envelope-Sender: zlatko.matic1@sb.t-com.hr
X-Envelope-Sender: zlatko.matic1@sb.t-com.hr
Received: from zlatkovyfkpgz6 (83-131-241-104.adsl.net.t-com.hr
	[83.131.241.104]) by ls401.t-com.hr (Qmlai) with SMTP id 7D8FFA8040;
	Thu,  6 Oct 2005 16:45:06 +0200 (CEST)
Message-ID: <000001c5ca84$8bfa2ed0$52bffea9@zlatkovyfkpgz6>
From: =?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr>
To: "Greg Campbell" <greg.campbell@us.michelin.com>
Cc: <pgsql-odbc@postgresql.org>, <pg-interfaces@postgresql.org>,
	<pgsql-interfaces@postgresql.org>, <pgsql-general@postgresql.org>
References: <000101c5c8d0$4a2fb340$1f291dc3@zlatkovyfkpgz6>
	<434284D6.3040708@us.michelin.com>
Subject: Re: [INTERFACES] [ODBC] Unbound text box, Text > 255 characters,
	MSAccess/PostgreSQL
Date: Wed, 5 Oct 2005 22:33:01 +0200
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-2";
	reply-type=original
X-Priority: 1
X-MSMail-Priority: High
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.32 required=5 tests=[AWL=-0.040,
	X_MSMAIL_PRIORITY_HIGH=0.267, X_PRIORITY_HIGH=0.093]
X-Spam-Level: 
X-Archive-Number: 200510/257
X-Sequence-Number: 84486

Hello, Greg and thanks for suggestions, but it didn't work with append=20
query. I just couldn't pass more than 255 characters long text as paramet=
er=20
of DAO query. But, fortunately, I solved the problem by using AddNew meth=
od=20
of DAO recordset to append new row. In this case I could pass directly th=
e=20
whole value of Me.TextBoxName. It seems that in this way Access can pass =
the=20
whole text (as Memo Type) to new row of recordset.
Otherwise if I want to pass the same value of the unbound text box by usi=
ng=20
an append query, it can pass just 255 characters long text.
Fortunately, it works with recordset object...

Thanks,

Zlatko

----- Original Message -----=20
From: "Greg Campbell" <greg.campbell@us.michelin.com>
To: "Zlatko Mati=E6" <zlatko.matic1@sb.t-com.hr>
Cc: <pgsql-odbc@postgresql.org>; <pg-interfaces@postgresql.org>;=20
<pgsql-interfaces@postgresql.org>; <pgsql-general@postgresql.org>
Sent: Tuesday, October 04, 2005 3:34 PM
Subject: Re: [INTERFACES] [ODBC] Unbound text box, Text > 255 characters,=
=20
MSAccess/PostgreSQL


What version of Access?
Confirm that Access is interpreting the target field as MEMO, (either loo=
k=20
at the linked table in design
mode, or use Tools->Analyze->Documenter).
For the query, determine the "type" of the parameter - Query=20
menu->Parameters. Be sure you are using type
MEMO.

By the way, 3271 is a Jet error -- Invalid property value.

Good luck.



Zlatko Mati=E6 wrote:

> Hello.
> I have the following problem with MS Access/PostgreSQL combination:
> There is a form in Access that has an unbound text box, used for enteri=
ng=20
> a commentary of a batch of records.
> There is a DAO Append Query that has a parameter that is passed from th=
e=20
> text box using parameter of DAO QueryDef object.
> I adjusted B7 parameter (Text as LongVarchar) in connection string (ODB=
C=20
> driver) to 1, so that Access links PostgreSQL Text fields as Memo field=
s=20
> in Access. The intention was to be able to enter unlimited length=20
> commentary into the field.
> But, although I can enter unlimited text by using bound text box in som=
e=20
> other forms, in this particular form I can't use bound control, so I ne=
ed=20
> to pass text from  UNBOUND control to the linked table by using DAO or =
ADO=20
> code. It seems that DAO query can't accept Memo as parameter, but only=20
> text. If my text exceeds length of 255, I have an VBA error 3271. If te=
xt=20
> in unbound text box is shorter that 255 everything is OK.
>
> So, is there any way to pass text of length >255 from unbound text box =
to=20
> Memo field of linked PostgreSQL table, by using DAO or ADO ?
>
> Thanks in advance,
>
> Zlatko



-------------------------------------------------------------------------=
-------



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings