We recently updated our
Terms and Conditions for TechRepublic Premium.
By clicking continue, you agree to these updated terms.
Invalid email/username and password combination supplied.
An email has been sent to you with instructions on how to reset your password.
Welcome to TechRepublic!
Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).
Sorry, I am not sure what you are asking for, or rather I do not know how you are doing the deletion and with what program?
What do you mean by error handling? System, DAO/ADO, or do you want to raise your own error and if so, then under what cercumstances?
Is this a bulk deletion? (DELETE * From Table). If so, then make sure you use the option: dbFailOnError.
Or are you are trying to say: When I delete records in a loop and there are no records to delete then an error occurs on the Delete command? If so, then always do a check on the BOF and EOF first to see if there are any(more) records to delete and after a delete move off the deleted record with MoveNext.
Other than that, just set an On Error Goto … statement at the begining of the proceedure.