Hiyas
I'm trying to save a boolean to a recordsets boolean field.
But it doesnt work as i'm used to from 'normal' VB.
Situation:
VBA-Modul reads from one table a string value and convert this string into a boolean, now this new value should be stored in a new table.
However, the line:
Would not let me save the boolean to the field.
The code is located in a sub of a VBA-modul inside MS Access 2000.
a) mGetValue(StringInputFieldName, RecordSetID) as String 'returns the FieldName's Value of the old table
b) BooleanHandler(StringInput) as Boolean 'returns true if length of string >0 and not empty.
c) rs.Fields refers to the new table in the current sub.
Can anyone tell my why i cant save the boolean to the checkbox field in access?
Greets
Arjuna
I'm trying to save a boolean to a recordsets boolean field.
But it doesnt work as i'm used to from 'normal' VB.
Situation:
VBA-Modul reads from one table a string value and convert this string into a boolean, now this new value should be stored in a new table.
However, the line:
Code:
rs.Fields("PerDu") = BooleanHandler(mGetValue("perDu", i))The code is located in a sub of a VBA-modul inside MS Access 2000.
a) mGetValue(StringInputFieldName, RecordSetID) as String 'returns the FieldName's Value of the old table
b) BooleanHandler(StringInput) as Boolean 'returns true if length of string >0 and not empty.
c) rs.Fields refers to the new table in the current sub.
Can anyone tell my why i cant save the boolean to the checkbox field in access?
Greets
Arjuna
