By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,068 Members | 1,734 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,068 IT Pros & Developers. It's quick & easy.

Unbound text box, text>255, MS Access/PostgreSQL

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Mon, 3 Oct 2005 01:15:54 +0200, "Zlatko Matić" <zl***********@sb.t-com.hr>
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


The easiest way is to open a DAO recordset, and add a new record to it.
Nov 13 '05 #2

P: n/a
You were right!
Thanks,

Zlatko

"Steve Jorgensen" <no****@nospam.nospam> je napisao u poruci interesnoj
grupi:uo********************************@4ax.com.. .
On Mon, 3 Oct 2005 01:15:54 +0200, "Zlatko Matić"
<zl***********@sb.t-com.hr>
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


The easiest way is to open a DAO recordset, and add a new record to it.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.