pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedUnbound text box, Text > 255 characters, MSAccess/PostgreSQL
3+ messages / 2 participants
[nested] [flat]
* Unbound text box, Text > 255 characters, MSAccess/PostgreSQL
@ 2005-10-02 23:14 =?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr>
2005-10-04 13:34 ` Re: [ODBC] Unbound text box, Text > 255 characters, MSAccess/PostgreSQL Greg Campbell <greg.campbell@us.michelin.com>
0 siblings, 1 reply; 3+ messages in thread
From: Zlatko Matić @ 2005-10-02 23:14 UTC (permalink / raw)
To: pgsql-odbc@postgresql.org; pg-interfaces@postgresql.org; pgsql-interfaces; pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [ODBC] Unbound text box, Text > 255 characters, MSAccess/PostgreSQL
2005-10-02 23:14 Unbound text box, Text > 255 characters, MSAccess/PostgreSQL =?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr>
@ 2005-10-04 13:34 ` Greg Campbell <greg.campbell@us.michelin.com>
2005-10-05 20:33 ` Re: [INTERFACES] [ODBC] Unbound text box, Text > 255 characters, MSAccess/PostgreSQL =?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr>
0 siblings, 1 reply; 3+ messages in thread
From: Greg Campbell @ 2005-10-04 13:34 UTC (permalink / raw)
To: Zlatko Matić <zlatko.matic1@sb.t-com.hr>; +Cc: pgsql-odbc@postgresql.org; pg-interfaces@postgresql.org; pgsql-interfaces; pgsql-general@postgresql.org
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
Attachments:
[text/x-vcard] greg.campbell.vcf (239B, ../../434284D6.3040708@us.michelin.com/2-greg.campbell.vcf)
download | inline:
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] [ODBC] Unbound text box, Text > 255 characters, MSAccess/PostgreSQL
2005-10-02 23:14 Unbound text box, Text > 255 characters, MSAccess/PostgreSQL =?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr>
2005-10-04 13:34 ` Re: [ODBC] Unbound text box, Text > 255 characters, MSAccess/PostgreSQL Greg Campbell <greg.campbell@us.michelin.com>
@ 2005-10-05 20:33 ` =?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr>
0 siblings, 0 replies; 3+ messages in thread
From: Zlatko Matić @ 2005-10-05 20:33 UTC (permalink / raw)
To: Greg Campbell <greg.campbell@us.michelin.com>; +Cc: pgsql-odbc@postgresql.org; pg-interfaces@postgresql.org; pgsql-interfaces; pgsql-general@postgresql.org
Hello, Greg and thanks for suggestions, but it didn't work with append
query. I just couldn't pass more than 255 characters long text as parameter
of DAO query. But, fortunately, I solved the problem by using AddNew method
of DAO recordset to append new row. In this case I could pass directly the
whole value of Me.TextBoxName. It seems that in this way Access can pass the
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 using
an append query, it can pass just 255 characters long text.
Fortunately, it works with recordset object...
Thanks,
Zlatko
----- Original Message -----
From: "Greg Campbell" <greg.campbell@us.michelin.com>
To: "Zlatko Matić" <zlatko.matic1@sb.t-com.hr>
Cc: <pgsql-odbc@postgresql.org>; <pg-interfaces@postgresql.org>;
<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,
MSAccess/PostgreSQL
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
--------------------------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-10-05 20:33 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-02 23:14 Unbound text box, Text > 255 characters, MSAccess/PostgreSQL =?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr>
2005-10-04 13:34 ` Greg Campbell <greg.campbell@us.michelin.com>
2005-10-05 20:33 ` =?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox