I've wrote some code to extract some data from lotus notes into access using odbc but I have a problem with the field types. If I use the code
Let texttest = rstnot![NorD]
This will set my text field to the correct value from the notes recordset field.
BUT
===
In some cases you cannot use the notes field names to query the data and have to use the command such as
Let texttest = rstnot!(1)
This should give me the same as before as the field NorD is the first one in the recordset and if I debug the code it does display the correct value but I get the error message.
Type declaration character does not match declared data type.
It does not matter what data type I try to move the field into it does not work. I have tried variant but nothing works
Can anyone help with this problem.
Let texttest = rstnot![NorD]
This will set my text field to the correct value from the notes recordset field.
BUT
===
In some cases you cannot use the notes field names to query the data and have to use the command such as
Let texttest = rstnot!(1)
This should give me the same as before as the field NorD is the first one in the recordset and if I debug the code it does display the correct value but I get the error message.
Type declaration character does not match declared data type.
It does not matter what data type I try to move the field into it does not work. I have tried variant but nothing works
Can anyone help with this problem.
