I cannot seem to get this entry to be accepted
into the intended table. I am getting the common
error message which tells me
cannot be found in collection ... corresponding requested name ordinal
I am thinking this is a datatype issue. I tried cstr(currentyear) but that
did not work. The datatype in the table is SMALLINT.
I've inlcuded only the related lines.
currentyear = DatePart("YYYY", date)
objInsertPoints.Fields("Registration") = currentyear
Thanks for any suggestions,