give users a warning when an update statement fails to add a new record to a recordset
When using an update statement (via Excel VBA) to add records to a database no error message is given when the update statement fails to add the record.
Using a loop to add records to a recordset, when one of the addnew statements fail no error message is given to the users and none of the other items in the loop following the record that fails get processed.
EG_If the loop has 100 records to add, if the 50th record fails, then the records 51 to 100 in the loop don't get processed. BUT NO ERROR MESSAGE!!!