i am tyring to insert data into the check table and am getting a "qodbc not supported" error. I am looping through an access table and grabbing the necessary info to insert into the check table ... here are the fields I am trying to insert: I am doing a similar thing to populate the vendor table with no error. thanks for any input
rdsQuickS8.Fields("AccountRefListID").Value = "25000-1177433363"
rdsQuickS8.Fields("AccountRefFullName").Value = "Bank of America - Section 8"
rdsQuickS8.Fields("PayeeEntityRefListID").Value = "800000CB-1224718952"
rdsQuickS8.Fields("PayeeEntityRefFullName").Value = rdsTemp.Fields("Name").Value
rdsQuickS8.Fields("RefNumber").Value = "1215"
rdsQuickS8.Fields("TxnDate").Value = Today
rdsQuickS8.Fields("Amount").Value = 99.0
rdsQuickS8.Fields("Memo").Value = rdsChecks.Fields("sMemo").Value
rdsQuickS8.Fields("AddressAddr1").Value = rdsTemp.Fields("Name").Value
rdsQuickS8.Fields("AddressAddr2").Value = rdsChecks.Fields("sStreet").Value
rdsQuickS8.Fields("AddressCity").Value = rdsChecks.Fields("sCity").Value
rdsQuickS8.Fields("AddressState").Value = rdsChecks.Fields("sState").Value
rdsQuickS8.Fields("AddressPostalCode").Value = rdsChecks.Fields("sZip").Value
|