VB Syntax, Problem with Access MEMO Fields & VB

Problem with Access MEMO Fields & VB

Author	Message
Garry Smit #1 / 3	Problem with Access MEMO Fields & VB Hi there; Using VB5 to read an MS Access97 MEMO type field through an ODBC driver. if I say txtField1 = rs!memofield (where rs is an RDO resultset) I get an invalid use of null error If I try txtFIeld1 = rs!memofield.getchunk(1000) - I get the same error. if I try If isnull(rs!memofield) ...... I get the same error if I try if isnull(rs!memofield.getchunk(1000)) I still get the {filter}y error. Anyone any ideas why I keep getting errors when retrieving a NON-NULL memo field. Much Appreciated Garry S Smith Software Engineer George-James Associates Ltd
Mon, 11 Feb 2002 03:00:00 GMT

Bryan Pollar #2 / 3	Problem with Access MEMO Fields & VB Try using a variant instead of a string. Bryan Quote: >Hi there; >Using VB5 to read an MS Access97 MEMO type field through an ODBC driver. >if I say > txtField1 = rs!memofield (where rs is an RDO resultset) >I get an invalid use of null error >If I try >txtFIeld1 = rs!memofield.getchunk(1000) - I get the same error. >if I try >If isnull(rs!memofield) ...... I get the same error >if I try >if isnull(rs!memofield.getchunk(1000)) I still get the {filter}y error. >Anyone any ideas why I keep getting errors when retrieving a NON-NULL memo >field. >Much Appreciated >Garry S Smith >Software Engineer >George-James Associates Ltd
Tue, 12 Feb 2002 03:00:00 GMT

MS #3 / 3	Problem with Access MEMO Fields & VB You should not use RDO with Access MDB files. Some RDO features don't work. (You just found one.) Some Access MDB features are unavailable. (Can't compact or repair the MDB.) Performance is poor and buggy. RDO was not designed to be used with MDB files. Use DAO instead. Regards, Simon Jones MillStream Designs Ltd Independent IT Consultants Hi there; Using VB5 to read an MS Access97 MEMO type field through an ODBC driver. if I say txtField1 = rs!memofield (where rs is an RDO resultset) I get an invalid use of null error If I try txtFIeld1 = rs!memofield.getchunk(1000) - I get the same error. if I try If isnull(rs!memofield) ...... I get the same error if I try if isnull(rs!memofield.getchunk(1000)) I still get the {filter}y error. Anyone any ideas why I keep getting errors when retrieving a NON-NULL memo field. Much Appreciated Garry S Smith Software Engineer George-James Associates Ltd
Wed, 13 Feb 2002 03:00:00 GMT

Page 1 of 1

[ 3 post ]